static readonly Empty |
An empty SQL string. |
static And(…) |
Joins the specified SQL fragments with the AND operator. |
static Clauses(…) |
Joins the specified SQL fragments with newlines. |
static ColumnNames(…) |
Returns a comma-delimited list of column names for a DTO of the specified type. (3 methods) |
static ColumnNames<T>() |
Returns a comma-delimited list of column names for a DTO of the specified type. |
static ColumnNames<T>(…) |
Returns a comma-delimited list of column names for a DTO of the specified type. (2 methods) |
static ColumnNamesWhere(…) |
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter. (3 methods) |
static ColumnNamesWhere<T>(…) |
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter. (3 methods) |
static ColumnParams(…) |
Returns a comma-delimited list of arbitrarily-named parameters for the column values of the specified DTO. |
static ColumnParamsWhere(…) |
Returns a comma-delimited list of arbitrarily-named parameters for the column values of the specified DTO for the properties whose names match the specified filter. |
static Concat(…) |
Concatenates SQL fragments. (2 methods) |
static DtoParamNames(…) |
Returns a comma-delimited list of named parameters for the properties of the specified DTO. (3 methods) |
static DtoParamNames<T>() |
Returns a comma-delimited list of named parameters for the properties of the specified DTO. |
static DtoParamNames<T>(…) |
Returns a comma-delimited list of named parameters for the properties of the specified DTO. (2 methods) |
static DtoParamNamesWhere(…) |
Returns a comma-delimited list of named parameters for the properties of the specified DTO whose names match the specified filter. (3 methods) |
static DtoParamNamesWhere<T>(…) |
Returns a comma-delimited list of named parameters for the properties of the specified DTO whose names match the specified filter. (3 methods) |
static Format(…) |
Creates SQL from a formatted string. |
static GroupBy(…) |
Creates SQL for a GROUP BY clause. If the SQLs are empty, the GROUP BY clause is omitted. |
static Having(…) |
Creates SQL for a HAVING clause. If the SQL is empty, the HAVING clause is omitted. |
static Join(…) |
Joins SQL fragments with the specified separator. (2 methods) |
static LikePrefixParam(…) |
Creates SQL for an arbitrarily-named parameter with the specified fragment of a LIKE pattern followed by a trailing % . |
static List(…) |
Creates SQL for a comma-delimited list of SQL fragments. |
static Name(…) |
Creates SQL for a quoted identifier. |
static Or(…) |
Joins the specified SQL fragments with the OR operator. |
static OrderBy(…) |
Creates SQL for an ORDER BY clause. If the SQLs are empty, the ORDER BY clause is omitted. |
static Param(…) |
Creates SQL for an arbitrarily-named parameter with the specified value. |
static ParamList(…) |
Creates SQL for a comma-delimted list of arbitrarily-named parameters with the specified values. (2 methods) |
static ParamTuple(…) |
Creates SQL for a comma-delimted list of arbitrarily-named parameters with the specified values, surrounded by parentheses. (2 methods) |
static Raw(…) |
Creates SQL from a raw string. |
static Tuple(…) |
Creates SQL for a comma-delimited list of SQL fragments, surrounded by parentheses. |
static Where(…) |
Creates SQL for a WHERE clause. If the SQL is empty, the WHERE clause is omitted. |
operator + |
Concatenates two SQL fragments. |