Search Results for

    Show / Hide Table of Contents

    Class SqlStatement

    Inheritance
    System.Object
    SqlStatement
    SqlCreateTableStatement
    SqlDropTableStatement
    SqlMultiInsertStatement
    SqlStatementWithQueryBase
    SqlTruncateTableStatement
    Implements
    IQueryElement
    ISqlExpressionWalkable
    Namespace: LinqToDB.SqlQuery
    Assembly: linq2db.dll
    Syntax
    public abstract class SqlStatement : object, IQueryElement, ISqlExpressionWalkable

    Properties

    | Improve this Doc View Source

    DebugSqlText

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

    ElementType

    Declaration
    public abstract QueryElementType ElementType { get; }
    Property Value
    Type Description
    QueryElementType
    | Improve this Doc View Source

    IsParameterDependent

    Declaration
    public abstract bool IsParameterDependent { get; set; }
    Property Value
    Type Description
    System.Boolean
    | Improve this Doc View Source

    ParentStatement

    Used internally for SQL Builder

    Declaration
    public SqlStatement ParentStatement { get; set; }
    Property Value
    Type Description
    SqlStatement
    | Improve this Doc View Source

    QueryType

    Declaration
    public abstract QueryType QueryType { get; }
    Property Value
    Type Description
    QueryType
    | Improve this Doc View Source

    SelectQuery

    Declaration
    public abstract SelectQuery SelectQuery { get; set; }
    Property Value
    Type Description
    SelectQuery
    | Improve this Doc View Source

    SqlQueryExtensions

    Declaration
    public List<SqlQueryExtension>? SqlQueryExtensions { get; set; }
    Property Value
    Type Description
    System.Nullable<List<SqlQueryExtension>>
    | Improve this Doc View Source

    SqlText

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

    Tag

    Declaration
    public SqlComment Tag { get; }
    Property Value
    Type Description
    SqlComment

    Methods

    | Improve this Doc View Source

    CollectParameters()

    Declaration
    public SqlParameter[] CollectParameters()
    Returns
    Type Description
    SqlParameter[]
    | Improve this Doc View Source

    GetTableSource(ISqlTableSource)

    Declaration
    public abstract ISqlTableSource GetTableSource(ISqlTableSource table)
    Parameters
    Type Name Description
    ISqlTableSource table
    Returns
    Type Description
    ISqlTableSource
    | Improve this Doc View Source

    IsDependedOn(SqlTable)

    Indicates when optimizer can not remove reference for particular table

    Declaration
    public virtual bool IsDependedOn(SqlTable table)
    Parameters
    Type Name Description
    SqlTable table
    Returns
    Type Description
    System.Boolean
    | Improve this Doc View Source

    PrepareQueryAndAliases(SqlStatement, AliasesContext, out AliasesContext)

    Declaration
    public static void PrepareQueryAndAliases(SqlStatement statement, AliasesContext prevAliasContext, out AliasesContext newAliasContext)
    Parameters
    Type Name Description
    SqlStatement statement
    AliasesContext prevAliasContext
    AliasesContext newAliasContext
    | Improve this Doc View Source

    ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

    Declaration
    public abstract StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
    Parameters
    Type Name Description
    StringBuilder sb
    Dictionary<IQueryElement, IQueryElement> dic
    Returns
    Type Description
    StringBuilder
    | Improve this Doc View Source

    Walk<TContext>(WalkOptions, TContext, Func<TContext, ISqlExpression, ISqlExpression>)

    Declaration
    public virtual ISqlExpression Walk<TContext>(WalkOptions options, TContext context, Func<TContext, ISqlExpression, ISqlExpression> func)
    Parameters
    Type Name Description
    WalkOptions options
    TContext context
    Func<TContext, ISqlExpression, ISqlExpression> func
    Returns
    Type Description
    ISqlExpression
    Type Parameters
    Name Description
    TContext
    | Improve this Doc View Source

    WalkQueries<TContext>(TContext, Func<TContext, SelectQuery, SelectQuery>)

    Declaration
    public abstract void WalkQueries<TContext>(TContext context, Func<TContext, SelectQuery, SelectQuery> func)
    Parameters
    Type Name Description
    TContext context
    Func<TContext, SelectQuery, SelectQuery> func
    Type Parameters
    Name Description
    TContext

    Implements

    IQueryElement
    ISqlExpressionWalkable

    Extension Methods

    Map.DeepCopy<T>(T)
    Sql.IsDistinctFrom<T>(T, T)
    Sql.IsNotDistinctFrom<T>(T, T)
    SqlExtensions.IsInsert(SqlStatement)
    SqlExtensions.NeedsIdentity(SqlStatement)
    SqlExtensions.IsUpdate(SqlStatement)
    SqlExtensions.IsDelete(SqlStatement)
    SqlExtensions.GetIdentityField(SqlStatement)
    SqlExtensions.GetInsertClause(SqlStatement)
    SqlExtensions.GetWithClause(SqlStatement)
    SqlExtensions.RequireInsertClause(SqlStatement)
    SqlExtensions.GetUpdateClause(SqlStatement)
    SqlExtensions.RequireUpdateClause(SqlStatement)
    SqlExtensions.GetOutputClause(SqlStatement)
    SqlExtensions.EnsureQuery(SqlStatement)
    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