Class SqlMergeStatement

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

public class SqlMergeStatement : SqlStatementWithQueryBase, IQueryElement, ISqlExpressionWalkable

Inheritance

object

SqlStatement

SqlStatementWithQueryBase

SqlMergeStatement

Implements

IQueryElement

ISqlExpressionWalkable

Inherited Members

SqlStatementWithQueryBase.With

SqlStatement.SqlText

SqlStatement.DebugSqlText

SqlStatement.ParentStatement

SqlStatement.CollectParameters()

SqlStatement.Tag

SqlStatement.SqlQueryExtensions

SqlStatement.PrepareQueryAndAliases(SqlStatement, AliasesContext, out AliasesContext)

SqlStatement.IsDependedOn(SqlTable)

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

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)

Constructors

SqlMergeStatement(SqlTable)

public SqlMergeStatement(SqlTable target)

Parameters

target SqlTable

Properties

ElementType

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

HasIdentityInsert

public bool HasIdentityInsert { get; }

Property Value

bool

Hint

public string? Hint { get; }

Property Value

string

IsParameterDependent

public override bool IsParameterDependent { get; set; }

Property Value

bool

On

public SqlSearchCondition On { get; }

Property Value

SqlSearchCondition

Operations

public List<SqlMergeOperationClause> Operations { get; }

Property Value

List<SqlMergeOperationClause>

Output

public SqlOutputClause? Output { get; set; }

Property Value

SqlOutputClause

QueryType

public override QueryType QueryType { get; }

Property Value

QueryType

SelectQuery

public override SelectQuery? SelectQuery { get; set; }

Property Value

SelectQuery

Source

public SqlTableLikeSource Source { get; }

Property Value

SqlTableLikeSource

Target

public SqlTableSource Target { get; }

Property Value

SqlTableSource

Methods

GetTableSource(ISqlTableSource)

public override ISqlTableSource? GetTableSource(ISqlTableSource table)

Parameters

table ISqlTableSource

Returns

ISqlTableSource

ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

public override 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 override 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 override 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