Class SqlInsertOrUpdateStatement

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

public sealed class SqlInsertOrUpdateStatement : SqlStatementWithQueryBase, IQueryElement

Inheritance

object

QueryElement

SqlStatement

SqlStatementWithQueryBase

SqlInsertOrUpdateStatement

Implements

IQueryElement

Inherited Members

SqlStatementWithQueryBase.IsParameterDependent

SqlStatementWithQueryBase.SelectQuery

SqlStatementWithQueryBase.With

SqlStatementWithQueryBase.GetTableSource(ISqlTableSource, out bool)

SqlStatement.SqlText

SqlStatement.QueryType

SqlStatement.IsParameterDependent

SqlStatement.ParentStatement

SqlStatement.SelectQuery

SqlStatement.Tag

SqlStatement.SqlQueryExtensions

SqlStatement.GetTableSource(ISqlTableSource, out bool)

SqlStatement.IsDependedOn(SqlTable)

SqlStatement.GetElementHashCode()

QueryElement.ReferenceComparer

QueryElement.ElementType

QueryElement.ToString(QueryElementTextWriter)

QueryElement.GetElementHashCode()

QueryElement.Accept(QueryElementVisitor)

Extension Methods

QueryHelper.AnyElement(IQueryElement, Func<IQueryElement, bool>)

QueryHelper.CanBeEvaluated(IQueryElement, EvaluationContext)

QueryHelper.CanBeEvaluated(IQueryElement, bool)

QueryHelper.EvaluateBoolExpression(IQueryElement, EvaluationContext, bool?)

QueryHelper.EvaluateExpression(IQueryElement, EvaluationContext)

QueryHelper.HasElement(IQueryElement, IQueryElement)

QueryHelper.HasParameter(IQueryElement)

QueryHelper.HasQueryParameter(IQueryElement)

QueryHelper.IsMutable(IQueryElement)

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

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

QueryVisitorExtensions.Find(IQueryElement?, QueryElementType)

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

QueryVisitorExtensions.FindExcept<TContext>(IQueryElement?, TContext, IQueryElement, Func<TContext, 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>)

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<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>)

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

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

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

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

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

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

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

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

QueryVisitorExtensions.Replace<T>(T, IDictionary<IQueryElement, IQueryElement>, params IQueryElement[])

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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>)

SqlExtensions.EnsureQuery(SqlStatement)

Constructors

SqlInsertOrUpdateStatement(SelectQuery?)

public SqlInsertOrUpdateStatement(SelectQuery? selectQuery)

Parameters

selectQuery SelectQuery

Properties

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

Insert

public SqlInsertClause Insert { get; set; }

Property Value

SqlInsertClause

QueryType

public override QueryType QueryType { get; }

Property Value

QueryType

Update

public SqlUpdateClause Update { get; set; }

Property Value

SqlUpdateClause

UpdateWhere

Optional predicate attached to the UPDATE branch of an upsert (e.g. the WHERE on ON CONFLICT ... DO UPDATE SET ... WHERE <cond> in PostgreSQL / SQLite, or the WHEN MATCHED AND <cond> in a MERGE-based emitter). null when the upsert has no conditional update gate. Populated by UpsertBuilder from .Update(v => v.When(...)).

public SqlSearchCondition? UpdateWhere { get; set; }

Property Value

SqlSearchCondition

Methods

Accept(QueryElementVisitor)

Visitor support.

public override IQueryElement Accept(QueryElementVisitor visitor)

Parameters

visitor QueryElementVisitor

Returns

IQueryElement

GetElementHashCode()

public override int GetElementHashCode()

Returns

int

GetTableSource(ISqlTableSource, out bool)

public override ISqlTableSource? GetTableSource(ISqlTableSource table, out bool noAlias)

Parameters

table ISqlTableSource

noAlias bool

Returns

ISqlTableSource

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter