Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere(Type type, Func<string, bool> filter)
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere(Type type, Func<string, bool> filter, string tableName)
This overload is used with SELECT statements when the table name (or alias) needs to be specified with each column name. If a tuple of DTOs is specified, a NULL column will separate the DTOs.
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere(Type type, Func<string, bool> filter, params string[] tableNames)
This overload is used with SELECT statements when the table name (or alias) needs to be specified with each column name. If a tuple of DTOs is specified, a NULL column will separate the DTOs.
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere<T>(Func<string, bool> filter)
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere<T>(Func<string, bool> filter, string tableName)
This overload is used with SELECT statements when the table name (or alias) needs to be specified with each column name. If a tuple of DTOs is specified, a NULL column will separate the DTOs.
Returns a comma-delimited list of column names for a DTO of the specified type for the properties whose names match the specified filter.
public static Sql ColumnNamesWhere<T>(Func<string, bool> filter, params string[] tableNames)
This overload is used with SELECT statements when the table name (or alias) needs to be specified with each column name. If a tuple of DTOs is specified, a NULL column will separate the DTOs.