Skip to main content

SqlTemplate

Common AutoQuery SQL Filter Templates

Assembly: ServiceStack.Interfaces.dll​
View Source​
Declaration
public static class SqlTemplate

Fields​

IsNull​

View Source​
Declaration
public const string IsNull = "{Field} IS NULL"

IsNotNull​

View Source​
Declaration
public const string IsNotNull = "{Field} IS NOT NULL"

GreaterThanOrEqual​

View Source​
Declaration
public const string GreaterThanOrEqual = "{Field} >= {Value}"

GreaterThan​

View Source​
Declaration
public const string GreaterThan = "{Field} > {Value}"

LessThan​

View Source​
Declaration
public const string LessThan = "{Field} < {Value}"

LessThanOrEqual​

View Source​
Declaration
public const string LessThanOrEqual = "{Field} <= {Value}"

NotEqual​

View Source​
Declaration
public const string NotEqual = "{Field} <> {Value}"

CaseSensitiveLike​

View Source​
Declaration
public const string CaseSensitiveLike = "{Field} LIKE {Value}"

CaseInsensitiveLike​

View Source​
Declaration
public const string CaseInsensitiveLike = "UPPER({Field}) LIKE UPPER({Value})"