Class SqlStatement

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

public abstract class SqlStatement : IQueryElement, ISqlExpressionWalkable

Inheritance

object

SqlStatement

Implements

IQueryElement

ISqlExpressionWalkable

Derived

SqlCreateTableStatement

SqlDropTableStatement

SqlMultiInsertStatement

SqlStatementWithQueryBase

SqlTruncateTableStatement

Extension Methods

QueryHelper.CanBeEvaluated(IQueryElement, EvaluationContext)

QueryHelper.CanBeEvaluated(IQueryElement, bool)

QueryHelper.EvaluateBoolExpression(IQueryElement, EvaluationContext, bool?)

QueryHelper.EvaluateExpression(IQueryElement, EvaluationContext)

QueryHelper.IsMutable(IQueryElement)

QueryHelper.ToDebugString(IQueryElement)

QueryHelper.TryEvaluateExpression(IQueryElement, EvaluationContext, out object?)

QueryVisitorExtensions.Find(IQueryElement?, QueryElementType)

QueryVisitorExtensions.Find(IQueryElement?, Func<IQueryElement, bool>)

QueryVisitorExtensions.Find<TContext>(IQueryElement?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

QueryVisitorExtensions.VisitParentFirst(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirst<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

QueryVisitorExtensions.Clone<T>(T?)

QueryVisitorExtensions.Clone<T>(T?, Dictionary<IQueryElement, IQueryElement>)

QueryVisitorExtensions.Clone<T>(T?, Func<IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Dictionary<IQueryElement, IQueryElement>, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.ConvertAll<T>(T, bool, Func<ConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, bool, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>, Func<ConvertVisitor<TContext>, bool>)

QueryVisitorExtensions.Convert<T>(T, Func<ConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<T>(T, Func<ConvertVisitor<object?>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<ConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

SqlExtensions.EnsureQuery(SqlStatement)

SqlExtensions.GetIdentityField(SqlStatement)

SqlExtensions.GetInsertClause(SqlStatement)

SqlExtensions.GetOutputClause(SqlStatement)

SqlExtensions.GetUpdateClause(SqlStatement)

SqlExtensions.GetWithClause(SqlStatement)

SqlExtensions.IsDelete(SqlStatement)

SqlExtensions.IsInsert(SqlStatement)

SqlExtensions.IsUpdate(SqlStatement)

SqlExtensions.NeedsIdentity(SqlStatement)

SqlExtensions.RequireInsertClause(SqlStatement)

SqlExtensions.RequireUpdateClause(SqlStatement)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Properties

DebugSqlText

protected string DebugSqlText { get; }

Property Value

string

ElementType

public abstract QueryElementType ElementType { get; }

Property Value

QueryElementType

IsParameterDependent

public abstract bool IsParameterDependent { get; set; }

Property Value

bool

ParentStatement

Used internally for SQL Builder

public SqlStatement? ParentStatement { get; set; }

Property Value

SqlStatement

QueryType

public abstract QueryType QueryType { get; }

Property Value

QueryType

SelectQuery

public abstract SelectQuery? SelectQuery { get; set; }

Property Value

SelectQuery

SqlQueryExtensions

public List<SqlQueryExtension>? SqlQueryExtensions { get; set; }

Property Value

List<SqlQueryExtension>

SqlText

public string SqlText { get; }

Property Value

string

Tag

public SqlComment? Tag { get; }

Property Value

SqlComment

Methods

CollectParameters()

[Obsolete("API will be removed in future versions")]
public SqlParameter[] CollectParameters()

Returns

SqlParameter[]

GetTableSource(ISqlTableSource)

public abstract ISqlTableSource? GetTableSource(ISqlTableSource table)

Parameters

table ISqlTableSource

Returns

ISqlTableSource

IsDependedOn(SqlTable)

Indicates when optimizer can not remove reference for particular table

public virtual bool IsDependedOn(SqlTable table)

Parameters

table SqlTable

Returns

bool

PrepareQueryAndAliases(SqlStatement, AliasesContext?, out AliasesContext)

public static void PrepareQueryAndAliases(SqlStatement statement, AliasesContext? prevAliasContext, out AliasesContext newAliasContext)

Parameters

statement SqlStatement

prevAliasContext AliasesContext

newAliasContext AliasesContext

ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

public abstract StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)

Parameters

sb StringBuilder

dic Dictionary<IQueryElement, IQueryElement>

Returns

StringBuilder

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

public abstract void WalkQueries<TContext>(TContext context, Func<TContext, SelectQuery, SelectQuery> func)

Parameters

context TContext

func Func<TContext, SelectQuery, SelectQuery>

Type Parameters

TContext

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

public virtual ISqlExpression? Walk<TContext>(WalkOptions options, TContext context, Func<TContext, ISqlExpression, ISqlExpression> func)

Parameters

options WalkOptions

context TContext

func Func<TContext, ISqlExpression, ISqlExpression>

Returns

ISqlExpression

Type Parameters

TContext