Sql class

Encapsulates parameterized SQL.

public abstract class Sql

Public Members

name description
static readonly Empty An empty SQL string.
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 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 Name(…) Creates SQL for a quoted identifier.
static Param(…) Creates SQL for an arbitrarily named parameter with the specified value.
static Raw(…) Creates SQL from a raw string.
operator + Concatenates two SQL fragments.

Protected Members

name description
Sql() The default constructor.

See Also