C# Class PetShop.Data.SqlUtil

Show file Open project: netTiers/netTiers Class Usage Examples

Public Properties

Property	Type	Description
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

Public Methods

Method	Description
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.

Method Details

Contains() public static method

Encodes the value for a SqlComparisonType.Contains expression.

public static Contains ( String value ) : String
value	String	The value.
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value ) : String
column	String
value	String
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Encode() public static method

Encodes the specified value for use in SQL expressions.

public static Encode ( String value ) : String
value	String
return	String

Encode() public static method

Encodes the specified value for use in SQL expressions and optionally surrounds the value with single-quotes.

public static Encode ( String value, bool surround ) : String
value	String
surround	bool
return	String

EndsWith() public static method

Encodes the value for a SqlComparisonType.EndsWith expression.

public static EndsWith ( String value ) : String
value	String	The value.
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value ) : String
column	String
value	String
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Equals() public static method

Encodes the value for a SqlComparisonType.Equals expression.

public static Equals ( String value ) : String
value	String	The value.
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value ) : String
column	String
value	String
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

GetEqualFormat() public static method

Gets the equal format string.

public static GetEqualFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetEqualFormat() public static method

Gets the equal format string.

public static GetEqualFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

GetLikeFormat() public static method

Gets the like format string.

public static GetLikeFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetLikeFormat() public static method

Gets the like format string.

public static GetLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

GetNotLikeFormat() public static method

Gets the not like format string.

public static GetNotLikeFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetNotLikeFormat() public static method

Gets the not like format string.

public static GetNotLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

IsNotNull() public static method

Creates an IS NOT NULL expression.

public static IsNotNull ( String column ) : String
column	String
return	String

IsNull() public static method

Creates an IS NULL expression.

public static IsNull ( String column ) : String
column	String
return	String

Like() public static method

Encodes the value for a SqlComparisonType.Like expression.

public static Like ( String value ) : String
value	String	The value.
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value ) : String
column	String
value	String
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

NotContains() public static method

Encodes the value for a SqlComparisonType.NotContains expression.

public static NotContains ( String value ) : String
value	String	The value.
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value ) : String
column	String
value	String
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

NotLike() public static method

Encodes the value for a SqlComparisonType.NotLike expression.

public static NotLike ( String value ) : String
value	String	The value.
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value ) : String
column	String
value	String
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

StartsWith() public static method

Encodes the value for a SqlComparisonType.StartsWith expression.

public static StartsWith ( String value ) : String
value	String	The value.
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value ) : String
column	String
value	String
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Property Details

AND public static property

SQL AND keyword.

public static String AND
return	String

ASC public static property

SQL ASC keyword.

public static String ASC
return	String

COMMA public static property

Delimiter for optional search terms.

public static String COMMA
return	String

DESC public static property

SQL DESC keyword.

public static String DESC
return	String

LEFT public static property

SQL grouping open character.

public static String LEFT
return	String

NULL public static property

SQL NULL keyword.

public static String NULL
return	String

OR public static property

SQL OR keyword.

public static String OR
return	String

PAGE_INDEX public static property

PageIndex Temp Table

public static String PAGE_INDEX
return	String

QUOTE public static property

Delimiter for quoted search terms.

public static String QUOTE
return	String

RIGHT public static property

SQL grouping close character.

public static String RIGHT
return	String

STAR public static property

Used as wildcard character within search text.

public static String STAR
return	String

TOKEN public static property

Used to represent quoted search terms.

public static String TOKEN
return	String

WILD public static property

SQL wildcard character.

public static String WILD
return	String