| Add(IQueryBuilder) | |
| Add(IQueryBuilder, Action<IQueryBuilder>) | |
| Add(IQueryBuilder, Byte) | |
| Add(IQueryBuilder, Decimal) | |
| Add(IQueryBuilder, Double) | |
| Add(IQueryBuilder, Int16) | |
| Add(IQueryBuilder, Int32) | |
| Add(IQueryBuilder, Int64) | |
| Add(IQueryBuilder, SByte) | |
| Add(IQueryBuilder, Single) | |
| Add(IQueryBuilder, UInt16) | |
| Add(IQueryBuilder, UInt32) | |
| Add(IQueryBuilder, UInt64) | |
| Add(IQueryBuilder, String, SchemeDbType) | |
| AddParameter(IDbCommand, String, Nullable<DbType>) | |
| AddParameter(IDbCommand, String, Nullable<DbType>, ParameterDirection) | |
| AddParameter(IDbCommand, String, Nullable<DbType>, Object) | |
| AddParameter(IDbCommand, String, Nullable<DbType>, ParameterDirection, Object) | |
| All | |
| And(IQueryBuilder) | |
| And(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| Any | |
| AppendCommaIfRequired | |
| AppendIdentifier | |
| AppendLine | |
| AppendLineIfRequired | |
| AppendMsSqlIdentifier | |
| AppendMsSqlType | |
| AppendMsSqlValue | |
| AppendPgSqlIdentifier | |
| AppendPgSqlType | |
| AppendPgSqlValue | |
| AppendType | |
| AppendValue | |
| AppendWhitespaceIfRequired | |
| As | |
| AsBit(IQueryBuilder, Action<IQueryBuilder>) | |
| AsBit(IQueryBuilder, Boolean) | |
| Assign | |
| Between(IQueryBuilder, Action<IQueryBuilder>, Action<IQueryBuilder>) | |
| Between(IQueryBuilder, Byte, Byte) | |
| Between(IQueryBuilder, Char, Char) | |
| Between(IQueryBuilder, Decimal, Decimal) | |
| Between(IQueryBuilder, Double, Double) | |
| Between(IQueryBuilder, Int16, Int16) | |
| Between(IQueryBuilder, Int32, Int32) | |
| Between(IQueryBuilder, Int64, Int64) | |
| Between(IQueryBuilder, SByte, SByte) | |
| Between(IQueryBuilder, Single, Single) | |
| Between(IQueryBuilder, UInt16, UInt16) | |
| Between(IQueryBuilder, UInt32, UInt32) | |
| Between(IQueryBuilder, UInt64, UInt64) | |
| Between(IQueryBuilder, DateTime, DateTime, SchemeDbType) | |
| Between(IQueryBuilder, DateTimeOffset, DateTimeOffset, SchemeDbType) | |
| By(IQueryBuilder, Action<IQueryBuilder>, SortOrder) | |
| By(IQueryBuilder, String, SortOrder) | |
| By(IQueryBuilder, String, String, SortOrder) | |
| C(IQueryBuilder, String) | |
| C(IQueryBuilder, String, String) | |
| C(IQueryBuilder, String, String[]) | |
| Call(IQueryBuilder, String, Action<IQueryBuilder>) | |
| Call(IQueryBuilderFactory, String, Action<IQueryBuilder>) | |
| Case | |
| CastAs(IQueryBuilder, Action<IQueryBuilder>, Type) | |
| CastAs(IQueryBuilder, Action<IQueryBuilder>, SchemeDbType) | |
| CastAs(IQueryBuilder, Action<IQueryBuilder>, SchemeDbType, Int64) | |
| CastAs(IQueryBuilder, Action<IQueryBuilder>, SchemeDbType, Byte, Nullable<Byte>) | |
| CastAs<T>(IQueryBuilder, Action<IQueryBuilder>) | |
| Coalesce | |
| Column(IQueryBuilder, String) | |
| Column(IQueryBuilder, String, String) | |
| Columns(IQueryBuilder, String) | |
| Columns(IQueryBuilder, String, String[]) | |
| Concat(IQueryBuilder) | |
| Concat(IQueryBuilder, Action<IQueryBuilder>) | |
| Concat(IQueryBuilder, String) | |
| Contains | |
| Count(IQueryBuilder) | |
| Count(IQueryBuilder, Action<IQueryBuilder>) | |
| Count(IQueryBuilder, String) | |
| Count(IQueryBuilder, String, String) | |
| CountBig(IQueryBuilder) | |
| CountBig(IQueryBuilder, Action<IQueryBuilder>) | |
| CountBig(IQueryBuilder, String) | |
| CountBig(IQueryBuilder, String, String) | |
| CreateParameter(IDbCommand, String, Nullable<DbType>) | |
| CreateParameter(IDbCommand, String, Nullable<DbType>, ParameterDirection) | |
| CreateParameter(IDbCommand, String, Nullable<DbType>, Object) | |
| CreateParameter(IDbCommand, String, Nullable<DbType>, ParameterDirection, Object) | |
| CreateTable(IQueryBuilder, String, Action<IQueryBuilder>) | |
| CreateTable(IQueryBuilderFactory, String, Action<IQueryBuilder>) | |
| CreateTempTable(IQueryBuilder, String, Action<IQueryBuilder>) | |
| CreateTempTable(IQueryBuilderFactory, String, Action<IQueryBuilder>) | |
| CrossJoin(IQueryBuilder) | |
| CrossJoin(IQueryBuilder, Action<IQueryBuilder>, String) | |
| CrossJoin(IQueryBuilder, String, String) | |
| DeleteFrom(IQueryBuilder, String, String) | |
| DeleteFrom(IQueryBuilderFactory, String, String) | |
| Divide(IQueryBuilder) | |
| Divide(IQueryBuilder, Action<IQueryBuilder>) | |
| Divide(IQueryBuilder, Byte) | |
| Divide(IQueryBuilder, Decimal) | |
| Divide(IQueryBuilder, Double) | |
| Divide(IQueryBuilder, Int16) | |
| Divide(IQueryBuilder, Int32) | |
| Divide(IQueryBuilder, Int64) | |
| Divide(IQueryBuilder, SByte) | |
| Divide(IQueryBuilder, Single) | |
| Divide(IQueryBuilder, UInt16) | |
| Divide(IQueryBuilder, UInt32) | |
| Divide(IQueryBuilder, UInt64) | |
| DropTable(IQueryBuilder, String) | |
| DropTable(IQueryBuilderFactory, String) | |
| E | |
| Else | |
| Equals | |
| Except | |
| ExecuteScalar<T> | |
| ExecuteScalarAsync<T> | |
| ExecuteSelect<T> | |
| ExecuteSelectAsync<T>(DbCommand, Func<IDataRecord, T>, CommandBehavior, CancellationToken) | |
| ExecuteSelectAsync<T>(DbManager, Func<IDataRecord, T>, CommandBehavior, CancellationToken) | |
| ExecuteSelectFirst<T> | |
| ExecuteSelectFirstAsync<T>(DbCommand, Func<IDataRecord, T>, CancellationToken) | |
| ExecuteSelectFirstAsync<T>(DbManager, Func<IDataRecord, T>, CancellationToken) | |
| ExecuteSelectFirstOrDefault<T>(IDbCommand, Func<IDataRecord, T>) | |
| ExecuteSelectFirstOrDefault<T>(IDbCommand, Func<IDataRecord, T>, T) | |
| ExecuteSelectFirstOrDefaultAsync<T>(DbCommand, Func<IDataRecord, T>, CancellationToken) | |
| ExecuteSelectFirstOrDefaultAsync<T>(DbManager, Func<IDataRecord, T>, CancellationToken) | |
| ExecuteSelectFirstOrDefaultAsync<T>(DbCommand, Func<IDataRecord, T>, T, CancellationToken) | |
| ExecuteSelectFirstOrDefaultAsync<T>(DbManager, Func<IDataRecord, T>, T, CancellationToken) | |
| Exists | |
| Expression | |
| From(IQueryBuilder) | |
| From(IQueryBuilder, Action<IQueryBuilder>, String) | |
| From(IQueryBuilder, String, String) | |
| From(IQueryBuilder, Action<IQueryBuilder>, String, String[]) | |
| FullTextSearch |
Функция осуществляет полнотекстовый поиск, для эффективной работы на колонках,
по которым осуществляется поиск необходим полнотекстовый (или gin) индекс.
Если индекса нет, то использовать эту функцию запрещено.
|
| Function | |
| GetBytes | |
| GetChars | |
| GetDateTimeUtc(IDataRecord, Int32) | |
| GetDateTimeUtc(IDataRecord, String) | |
| GetDbms(DbManager) | |
| GetDbms(DbProviderFactory) | |
| GetDbms(IDbCommand) | |
| GetDbms(IDbConnection) | |
| GetNullableBoolean | |
| GetNullableByte | |
| GetNullableBytes | |
| GetNullableChar | |
| GetNullableChars | |
| GetNullableDateTime | |
| GetNullableDateTimeUtc(IDataRecord, Int32) | |
| GetNullableDateTimeUtc(IDataRecord, String) | |
| GetNullableDecimal | |
| GetNullableDouble | |
| GetNullableGuid | |
| GetNullableInt16 | |
| GetNullableInt32 | |
| GetNullableInt64 | |
| GetNullableSingle | |
| GetNullableString | |
| GetSequentialBytesAsync |
Выполняет чтение массива байт с указанным индексом, где предполагается, что поле в БД не равно null.
Рекомендуется использовать этот метод вместо GetBytes(IDataRecord, Int32), если массив байт может быть размером более 5 Мб.
Для этого требуется открыть reader следующим образом:
DbManager.ExecuteReaderAsync(CommandBehavior.SequentialAccess).
|
| GetSequentialNullableBytesAsync |
Выполняет чтение массива байт с указанным индексом, где предполагается, что поле в БД может быть равно null.
Рекомендуется использовать этот метод вместо GetNullableBytes(IDataRecord, Int32), если массив байт может быть размером более 5 Мб.
Для этого требуется открыть reader следующим образом:
DbManager.ExecuteReaderAsync(CommandBehavior.SequentialAccess).
|
| GetSequentialNullableStringAsync |
Выполняет чтение строки с указанным индексом, где предполагается, что строка в БД может быть равна null.
Рекомендуется использовать этот метод вместо GetNullableString(IDataRecord, Int32), если строка может быть размером более 5 Мб.
Для этого требуется открыть reader следующим образом:
DbManager.ExecuteReaderAsync(CommandBehavior.SequentialAccess).
|
| GetSequentialStringAsync |
Выполняет чтение строки с указанным индексом, где предполагается, что строка в БД не равна null.
Рекомендуется использовать этот метод вместо GetString(Int32), если строка может быть размером более 5 Мб.
Для этого требуется открыть reader следующим образом:
DbManager.ExecuteReaderAsync(CommandBehavior.SequentialAccess).
|
| GetValue<T>(IDataRecord, Int32) | |
| GetValue<T>(IDataRecord, String) | |
| Greater | |
| GreaterOrEquals | |
| GroupBy(IQueryBuilder) | |
| GroupBy(IQueryBuilder, Action<IQueryBuilder>) | |
| GroupBy(IQueryBuilder, String) | |
| GroupBy(IQueryBuilder, String, String) | |
| Having(IQueryBuilder) | |
| Having(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| I | |
| Identifier | |
| If(IQueryBuilder, Boolean, Action<IQueryBuilder>) | |
| If(IQueryBuilder, Dbms, Action<IQueryBuilder>) | |
| If(IQueryBuilderFactory, Dbms, Action<IQueryBuilder>) | |
| In(IQueryBuilder, Byte[]) | |
| In(IQueryBuilder, Char[]) | |
| In(IQueryBuilder, DateTime[]) | |
| In(IQueryBuilder, DateTimeOffset[]) | |
| In(IQueryBuilder, Decimal[]) | |
| In(IQueryBuilder, Double[]) | |
| In(IQueryBuilder, Guid[]) | |
| In(IQueryBuilder, Int16[]) | |
| In(IQueryBuilder, Int32[]) | |
| In(IQueryBuilder, Int64[]) | |
| In(IQueryBuilder, Object[]) | |
| In(IQueryBuilder, SByte[]) | |
| In(IQueryBuilder, Single[]) | |
| In(IQueryBuilder, String[]) | |
| In(IQueryBuilder, UInt16[]) | |
| In(IQueryBuilder, UInt32[]) | |
| In(IQueryBuilder, UInt64[]) | |
| In(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| In<T>(IQueryBuilder, T[]) | |
| In<T>(IQueryBuilder, IEnumerable<T>) | |
| InnerJoin(IQueryBuilder) | |
| InnerJoin(IQueryBuilder, Action<IQueryBuilder>, String) | |
| InnerJoin(IQueryBuilder, String, String) | |
| InnerJoinLateral(IQueryBuilder) | |
| InnerJoinLateral(IQueryBuilder, Action<IQueryBuilder>, String) | |
| InsertInto(IQueryBuilder, String) | |
| InsertInto(IQueryBuilderFactory, String) | |
| InsertInto(IQueryBuilder, String, String[]) | |
| InsertInto(IQueryBuilderFactory, String, String[]) | |
| Intersect | |
| IsFullTextSearchEnabled |
Возвращает результат проверки того, включён ли полнотекстовый поиск.
Возвращает целое число int, равное 1, если полнотекстовый поиск включён, или 0, если он отключён.
|
| IsNotNull | |
| IsNull | |
| Join | |
| LeftJoin(IQueryBuilder) | |
| LeftJoin(IQueryBuilder, Action<IQueryBuilder>, String) | |
| LeftJoin(IQueryBuilder, String, String) | |
| LeftJoinLateral(IQueryBuilder) | |
| LeftJoinLateral(IQueryBuilder, Action<IQueryBuilder>, String) | |
| Less | |
| LessOrEquals | |
| Like(IQueryBuilder, Action<IQueryBuilder>, Char) | |
| Like(IQueryBuilder, String, Char) | |
| Limit | |
| LowerC(IQueryBuilder, String) | |
| LowerC(IQueryBuilder, String, String) | |
| LowerColumn | |
| LowerP | |
| LowerParameter | |
| Match |
Оператора соответствия "@@"
|
| Max(IQueryBuilder, Action<IQueryBuilder>) | |
| Max(IQueryBuilder, String) | |
| Max(IQueryBuilder, String, String) | |
| Min(IQueryBuilder, Action<IQueryBuilder>) | |
| Min(IQueryBuilder, String) | |
| Min(IQueryBuilder, String, String) | |
| Multiply(IQueryBuilder) | |
| Multiply(IQueryBuilder, Action<IQueryBuilder>) | |
| Multiply(IQueryBuilder, Byte) | |
| Multiply(IQueryBuilder, Decimal) | |
| Multiply(IQueryBuilder, Double) | |
| Multiply(IQueryBuilder, Int16) | |
| Multiply(IQueryBuilder, Int32) | |
| Multiply(IQueryBuilder, Int64) | |
| Multiply(IQueryBuilder, SByte) | |
| Multiply(IQueryBuilder, Single) | |
| Multiply(IQueryBuilder, UInt16) | |
| Multiply(IQueryBuilder, UInt32) | |
| Multiply(IQueryBuilder, UInt64) | |
| N | |
| NewGuid | |
| NoLock | |
| Not(IQueryBuilder) | |
| Not(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| NotBetween(IQueryBuilder, Action<IQueryBuilder>, Action<IQueryBuilder>) | |
| NotBetween(IQueryBuilder, Byte, Byte) | |
| NotBetween(IQueryBuilder, Char, Char) | |
| NotBetween(IQueryBuilder, Decimal, Decimal) | |
| NotBetween(IQueryBuilder, Double, Double) | |
| NotBetween(IQueryBuilder, Int16, Int16) | |
| NotBetween(IQueryBuilder, Int32, Int32) | |
| NotBetween(IQueryBuilder, Int64, Int64) | |
| NotBetween(IQueryBuilder, SByte, SByte) | |
| NotBetween(IQueryBuilder, Single, Single) | |
| NotBetween(IQueryBuilder, UInt16, UInt16) | |
| NotBetween(IQueryBuilder, UInt32, UInt32) | |
| NotBetween(IQueryBuilder, UInt64, UInt64) | |
| NotBetween(IQueryBuilder, DateTime, DateTime, SchemeDbType) | |
| NotBetween(IQueryBuilder, DateTimeOffset, DateTimeOffset, SchemeDbType) | |
| NotEquals | |
| NotExists | |
| NotIn(IQueryBuilder, Byte[]) | |
| NotIn(IQueryBuilder, Char[]) | |
| NotIn(IQueryBuilder, DateTime[]) | |
| NotIn(IQueryBuilder, DateTimeOffset[]) | |
| NotIn(IQueryBuilder, Decimal[]) | |
| NotIn(IQueryBuilder, Double[]) | |
| NotIn(IQueryBuilder, Guid[]) | |
| NotIn(IQueryBuilder, Int16[]) | |
| NotIn(IQueryBuilder, Int32[]) | |
| NotIn(IQueryBuilder, Int64[]) | |
| NotIn(IQueryBuilder, Object[]) | |
| NotIn(IQueryBuilder, SByte[]) | |
| NotIn(IQueryBuilder, Single[]) | |
| NotIn(IQueryBuilder, String[]) | |
| NotIn(IQueryBuilder, UInt16[]) | |
| NotIn(IQueryBuilder, UInt32[]) | |
| NotIn(IQueryBuilder, UInt64[]) | |
| NotIn(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| NotIn<T>(IQueryBuilder, T[]) | |
| NotLike(IQueryBuilder, Action<IQueryBuilder>, Char) | |
| NotLike(IQueryBuilder, String, Char) | |
| Now | |
| NowUtc | Устарело. |
| On(IQueryBuilder) | |
| On(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| OptionMaxRecursion |
Задаёт подсказку для MS SQL Server MAXRECURSION.
|
| Or(IQueryBuilder) | |
| Or(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| OrderBy(IQueryBuilder) | |
| OrderBy(IQueryBuilder, Action<IQueryBuilder>, SortOrder) | |
| OrderBy(IQueryBuilder, String, SortOrder) | |
| OrderBy(IQueryBuilder, String, String, SortOrder) | |
| OuterJoin(IQueryBuilder) | |
| OuterJoin(IQueryBuilder, Action<IQueryBuilder>, String) | |
| OuterJoin(IQueryBuilder, String, String) | |
| P(IQueryBuilder, String) | |
| P(IQueryBuilder, String[]) | |
| Parameter | |
| Parameters | |
| Q(IQueryBuilder, String) | |
| Q(IQueryBuilderFactory, String) | |
| RightJoin(IQueryBuilder) | |
| RightJoin(IQueryBuilder, Action<IQueryBuilder>, String) | |
| RightJoin(IQueryBuilder, String, String) | |
| Round | |
| Select(IQueryBuilder) | |
| Select(IQueryBuilderFactory) | |
| SelectDistinct(IQueryBuilder) | |
| SelectDistinct(IQueryBuilderFactory) | |
| SelectExists(IQueryBuilder, Action<IQueryBuilder>) | |
| SelectExists(IQueryBuilderFactory, Action<IQueryBuilder>) | |
| SetFunctionName(IDbCommand, String) | |
| SetFunctionName(IDbCommand, String, String) | |
| SetProcedureName(IDbCommand, String) | |
| SetProcedureName(IDbCommand, String, String) | |
| Substract(IQueryBuilder) | |
| Substract(IQueryBuilder, Action<IQueryBuilder>) | |
| Substract(IQueryBuilder, Byte) | |
| Substract(IQueryBuilder, Decimal) | |
| Substract(IQueryBuilder, Double) | |
| Substract(IQueryBuilder, Int16) | |
| Substract(IQueryBuilder, Int32) | |
| Substract(IQueryBuilder, Int64) | |
| Substract(IQueryBuilder, SByte) | |
| Substract(IQueryBuilder, Single) | |
| Substract(IQueryBuilder, UInt16) | |
| Substract(IQueryBuilder, UInt32) | |
| Substract(IQueryBuilder, UInt64) | |
| Sum(IQueryBuilder, Action<IQueryBuilder>) | |
| Sum(IQueryBuilder, String) | |
| Sum(IQueryBuilder, String, String) | |
| T | |
| Table | |
| Top | |
| ToTsquery | |
| ToTsvector | |
| Type(IQueryBuilder, Type) | |
| Type(IQueryBuilder, SchemeDbType) | |
| Type(IQueryBuilder, SchemeType) | |
| Type(IQueryBuilder, SchemeDbType, Int64) | |
| Type(IQueryBuilder, SchemeDbType, Byte, Nullable<Byte>) | |
| Type<T>(IQueryBuilder) | |
| Union | |
| UnionAll | |
| Update(IQueryBuilder, String, String) | |
| Update(IQueryBuilderFactory, String, String) | |
| V(IQueryBuilder, Boolean) | |
| V(IQueryBuilder, Byte) | |
| V(IQueryBuilder, Char) | |
| V(IQueryBuilder, Decimal) | |
| V(IQueryBuilder, Double) | |
| V(IQueryBuilder, Guid) | |
| V(IQueryBuilder, Int16) | |
| V(IQueryBuilder, Int32) | |
| V(IQueryBuilder, Int64) | |
| V(IQueryBuilder, Object) | |
| V(IQueryBuilder, SByte) | |
| V(IQueryBuilder, Single) | |
| V(IQueryBuilder, UInt16) | |
| V(IQueryBuilder, UInt32) | |
| V(IQueryBuilder, UInt64) | |
| V(IQueryBuilder, DateTime, SchemeDbType) | |
| V(IQueryBuilder, DateTimeOffset, SchemeDbType) | |
| V(IQueryBuilder, String, SchemeDbType) | |
| Value(IQueryBuilder, Boolean) | |
| Value(IQueryBuilder, Byte) | |
| Value(IQueryBuilder, Byte[]) | |
| Value(IQueryBuilder, Char) | |
| Value(IQueryBuilder, Decimal) | |
| Value(IQueryBuilder, Double) | |
| Value(IQueryBuilder, Guid) | |
| Value(IQueryBuilder, Int16) | |
| Value(IQueryBuilder, Int32) | |
| Value(IQueryBuilder, Int64) | |
| Value(IQueryBuilder, Object) | |
| Value(IQueryBuilder, SByte) | |
| Value(IQueryBuilder, Single) | |
| Value(IQueryBuilder, UInt16) | |
| Value(IQueryBuilder, UInt32) | |
| Value(IQueryBuilder, UInt64) | |
| Value(IQueryBuilder, DateTime, SchemeDbType) | |
| Value(IQueryBuilder, DateTimeOffset, SchemeDbType) | |
| Value(IQueryBuilder, String, SchemeDbType) | |
| Values(IQueryBuilder, Action<IQueryBuilder>) | |
| Values<T>(IQueryBuilder, IEnumerable<T>, Action<IQueryBuilder, T>) | |
| When | |
| Where(IQueryBuilder) | |
| Where(IQueryBuilder, Action<IQueryBuilder>, Boolean) | |
| With(IQueryBuilder, String, Action<IQueryBuilder>, String[], Boolean) | |
| With(IQueryBuilderFactory, String, Action<IQueryBuilder>, String[], Boolean) | |
| Z | |