• Главная
• Nettiers
• AdventureWorks
• Data
• SqlUtil

C# Класс Nettiers.AdventureWorks.Data.SqlUtil

Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
AND	String
ASC	String
COMMA	String
DESC	String
LEFT	String
NULL	String
OR	String
PAGE_INDEX	String
QUOTE	String
RIGHT	String
STAR	String
TOKEN	String
WILD	String

Открытые методы

Метод	Описание
Contains ( String value ) : String	Encodes the value for a SqlComparisonType.Contains expression.
Contains ( String column, String value ) : String	Creates a SqlComparisonType.Contains expression.
Contains ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Contains expression.
Contains ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.Contains expression.
Encode ( String value ) : String	Encodes the specified value for use in SQL expressions.
Encode ( String value, bool surround ) : String	Encodes the specified value for use in SQL expressions and optionally surrounds the value with single-quotes.
EndsWith ( String value ) : String	Encodes the value for a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value ) : String	Creates a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.EndsWith expression.
Equals ( String value ) : String	Encodes the value for a SqlComparisonType.Equals expression.
Equals ( String column, String value ) : String	Creates an SqlComparisonType.Equals expression.
Equals ( String column, String value, bool ignoreCase ) : String	Creates an SqlComparisonType.Equals expression.
Equals ( String column, String value, bool ignoreCase, bool surround ) : String	Creates an SqlComparisonType.Equals expression.
GetEqualFormat ( bool ignoreCase ) : String	Gets the equal format string.
GetEqualFormat ( bool ignoreCase, bool surround ) : String	Gets the equal format string.
GetLikeFormat ( bool ignoreCase ) : String	Gets the like format string.
GetLikeFormat ( bool ignoreCase, bool surround ) : String	Gets the like format string.
GetNotLikeFormat ( bool ignoreCase ) : String	Gets the not like format string.
GetNotLikeFormat ( bool ignoreCase, bool surround ) : String	Gets the not like format string.
IsNotNull ( String column ) : String	Creates an IS NOT NULL expression.
IsNull ( String column ) : String	Creates an IS NULL expression.
Like ( String value ) : String	Encodes the value for a SqlComparisonType.Like expression.
Like ( String column, String value ) : String	Creates a SqlComparisonType.Like expression.
Like ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Like expression.
Like ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.Like expression.
NotContains ( String value ) : String	Encodes the value for a SqlComparisonType.NotContains expression.
NotContains ( String column, String value ) : String	Creates a SqlComparisonType.NotContains expression.
NotContains ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.NotContains expression.
NotContains ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.NotContains expression.
NotLike ( String value ) : String	Encodes the value for a SqlComparisonType.NotLike expression.
NotLike ( String column, String value ) : String	Creates a SqlComparisonType.NotLike expression.
NotLike ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.NotLike expression.
NotLike ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.NotLike expression.
StartsWith ( String value ) : String	Encodes the value for a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value ) : String	Creates a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.StartsWith expression.

Описание методов

Описание свойств