Search Results for

    Show / Hide Table of Contents

    Interface ISqlBuilder

    Namespace: LinqToDB.SqlProvider
    Assembly: linq2db.dll
    Syntax
    public interface ISqlBuilder

    Properties

    | Improve this Doc View Source

    MappingSchema

    Declaration
    MappingSchema MappingSchema { get; }
    Property Value
    Type Description
    MappingSchema
    | Improve this Doc View Source

    Name

    Declaration
    string Name { get; }
    Property Value
    Type Description
    System.String
    | Improve this Doc View Source

    QueryName

    Declaration
    string? QueryName { get; }
    Property Value
    Type Description
    System.Nullable<System.String>
    | Improve this Doc View Source

    SqlProviderFlags

    Declaration
    SqlProviderFlags SqlProviderFlags { get; }
    Property Value
    Type Description
    SqlProviderFlags
    | Improve this Doc View Source

    StringBuilder

    Declaration
    StringBuilder StringBuilder { get; }
    Property Value
    Type Description
    StringBuilder
    | Improve this Doc View Source

    TableIDs

    Declaration
    Dictionary<string, TableIDInfo>? TableIDs { get; }
    Property Value
    Type Description
    System.Nullable<Dictionary<System.String, TableIDInfo>>
    | Improve this Doc View Source

    TablePath

    Declaration
    string? TablePath { get; }
    Property Value
    Type Description
    System.Nullable<System.String>

    Methods

    | Improve this Doc View Source

    ApplyQueryHints(String, IReadOnlyCollection<String>)

    Declaration
    string ApplyQueryHints(string sqlText, IReadOnlyCollection<string> queryHints)
    Parameters
    Type Name Description
    System.String sqlText
    IReadOnlyCollection<System.String> queryHints
    Returns
    Type Description
    System.String
    | Improve this Doc View Source

    BuildDataType(StringBuilder, SqlDataType)

    Declaration
    StringBuilder BuildDataType(StringBuilder sb, SqlDataType dataType)
    Parameters
    Type Name Description
    StringBuilder sb
    SqlDataType dataType
    Returns
    Type Description
    StringBuilder
    | Improve this Doc View Source

    BuildExpression(StringBuilder, ISqlExpression, Boolean)

    Declaration
    void BuildExpression(StringBuilder sb, ISqlExpression expr, bool buildTableName)
    Parameters
    Type Name Description
    StringBuilder sb
    ISqlExpression expr
    System.Boolean buildTableName
    | Improve this Doc View Source

    BuildObjectName(StringBuilder, SqlObjectName, ConvertType, Boolean, TableOptions)

    Writes database object name into provided StringBuilder instance.

    Declaration
    StringBuilder BuildObjectName(StringBuilder sb, SqlObjectName name, ConvertType objectType = ConvertType.NameToQueryTable, bool escape = true, TableOptions tableOptions = default(TableOptions))
    Parameters
    Type Name Description
    StringBuilder sb

    String builder for generated object name.

    LinqToDB.SqlQuery.SqlObjectName name

    Name of database object (e.g. table, view, procedure or function).

    ConvertType objectType

    Type of database object, used to select proper name converter.

    System.Boolean escape

    If true, apply required escaping to name components. Must be true except rare cases when escaping is not needed.

    TableOptions tableOptions

    Table options if called for table. Used to properly generate names for temporary tables.

    Returns
    Type Description
    StringBuilder

    sb parameter value.

    | Improve this Doc View Source

    BuildSql(Int32, SqlStatement, StringBuilder, OptimizationContext, Int32)

    Declaration
    void BuildSql(int commandNumber, SqlStatement statement, StringBuilder sb, OptimizationContext optimizationContext, int startIndent = 0)
    Parameters
    Type Name Description
    System.Int32 commandNumber
    SqlStatement statement
    StringBuilder sb
    OptimizationContext optimizationContext
    System.Int32 startIndent
    | Improve this Doc View Source

    BuildSqlID(Sql.SqlID)

    Declaration
    string? BuildSqlID(Sql.SqlID id)
    Parameters
    Type Name Description
    Sql.SqlID id
    Returns
    Type Description
    System.Nullable<System.String>
    | Improve this Doc View Source

    CommandCount(SqlStatement)

    Declaration
    int CommandCount(SqlStatement statement)
    Parameters
    Type Name Description
    SqlStatement statement
    Returns
    Type Description
    System.Int32
    | Improve this Doc View Source

    Convert(StringBuilder, String, ConvertType)

    Declaration
    StringBuilder Convert(StringBuilder sb, string value, ConvertType convertType)
    Parameters
    Type Name Description
    StringBuilder sb
    System.String value
    ConvertType convertType
    Returns
    Type Description
    StringBuilder
    | Improve this Doc View Source

    ConvertInline(String, ConvertType)

    Declaration
    string ConvertInline(string value, ConvertType convertType)
    Parameters
    Type Name Description
    System.String value
    ConvertType convertType
    Returns
    Type Description
    System.String
    | Improve this Doc View Source

    GetIdentityExpression(SqlTable)

    Declaration
    ISqlExpression GetIdentityExpression(SqlTable table)
    Parameters
    Type Name Description
    SqlTable table
    Returns
    Type Description
    ISqlExpression
    | Improve this Doc View Source

    GetMaxValueSql(EntityDescriptor, ColumnDescriptor)

    Declaration
    string GetMaxValueSql(EntityDescriptor entity, ColumnDescriptor column)
    Parameters
    Type Name Description
    EntityDescriptor entity
    ColumnDescriptor column
    Returns
    Type Description
    System.String
    | Improve this Doc View Source

    GetReserveSequenceValuesSql(Int32, String)

    Declaration
    string GetReserveSequenceValuesSql(int count, string sequenceName)
    Parameters
    Type Name Description
    System.Int32 count
    System.String sequenceName
    Returns
    Type Description
    System.String
    | Improve this Doc View Source

    PrintParameters(IDataContext, StringBuilder, Nullable<IEnumerable<DbParameter>>)

    Declaration
    StringBuilder PrintParameters(IDataContext dataContext, StringBuilder sb, IEnumerable<DbParameter>? parameters)
    Parameters
    Type Name Description
    IDataContext dataContext
    StringBuilder sb
    System.Nullable<IEnumerable<DbParameter>> parameters
    Returns
    Type Description
    StringBuilder

    Extension Methods

    Map.DeepCopy<T>(T)
    Sql.IsDistinctFrom<T>(T, T)
    Sql.IsNotDistinctFrom<T>(T, T)
    SqlExtensions.In<T>(T, IEnumerable<T>)
    SqlExtensions.In<T>(T, IQueryable<T>)
    SqlExtensions.In<T>(T, T[])
    SqlExtensions.In<T>(T, T, T)
    SqlExtensions.In<T>(T, T, T, T)
    SqlExtensions.NotIn<T>(T, IEnumerable<T>)
    SqlExtensions.NotIn<T>(T, IQueryable<T>)
    SqlExtensions.NotIn<T>(T, T[])
    SqlExtensions.NotIn<T>(T, T, T)
    SqlExtensions.NotIn<T>(T, T, T, T)
    • Improve this Doc
    • View Source
    In This Article
    Back to top Copyright © 2011-2022 linq2db.com

    Generated by DocFX