Skip to main content

sqlutils-class

public static class Korzh.EasyQuery.Db.SqlUtils

Assembly: Korzh.EasyQuery.Db.dll

Static Methods

NameTypeDescription
ComposeTableAlias(Table tbl, SqlFormats formats)string
ContainsAggregateFunctions(string sqlExpr)boolDetermines whether the SQL expression contains at aggregate function.
DataTypeToDbType(DataType dt)DbTypeConverts DataType enum value to corresponding DbType
EdmxTypeToDataType(string edmxType)DataTypeConverts type form EDMX file into DataType enumeration.
ExcludeFieldsFromExpr(DbModel model, string expr)List<string>
ExtractTablesByExpr(DbModel model, string expr, TableList tableList)void
HasSelectStatement(string sqlExpr)boolDetermines whether the SQL expression contains a SELECT statement inside it.
ReplaceTablesInExprWithAliases(DbModel model, string expr, SqlFormats formats)string
SqlServerTypeToDataType(string sqlType)DataTypeConverts SQL Server data types to DataType enumeration.