UpdateSqlGenerator UpdateSqlGenerator Class

Definition

public abstract class UpdateSqlGenerator : IUpdateSqlGenerator
Public MustInherit Class UpdateSqlGenerator
    Implements IUpdateSqlGenerator
Inheritance
System.ObjectSystem.Object
UpdateSqlGeneratorUpdateSqlGenerator
Implements

Inherited Members

System.Object

System.Object.ToString()System.Object.ToString()
System.Object.Equals(System.Object)System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()System.Object.GetHashCode()
System.Object.GetType()System.Object.GetType()
System.Object.MemberwiseClone()System.Object.MemberwiseClone()

Constructors

UpdateSqlGenerator(ISqlGenerationHelper) UpdateSqlGenerator(ISqlGenerationHelper)

protected UpdateSqlGenerator(ISqlGenerationHelper sqlGenerationHelper)
Protected Sub New(sqlGenerationHelper As ISqlGenerationHelper)
Parameters

Properties

SqlGenerationHelper SqlGenerationHelper

protected virtual ISqlGenerationHelper SqlGenerationHelper { get; }
Protected Overridable ReadOnly Property SqlGenerationHelper As ISqlGenerationHelper

Methods

AppendBatchHeader(StringBuilder) AppendBatchHeader(StringBuilder)

public virtual void AppendBatchHeader(StringBuilder commandStringBuilder)
Public Overridable Sub AppendBatchHeader(commandStringBuilder As StringBuilder)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder

AppendDeleteCommand(StringBuilder, String, String, IReadOnlyList) AppendDeleteCommand(StringBuilder, String, String, IReadOnlyList(Of ColumnModification))

protected virtual void AppendDeleteCommand(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> conditionOperations)
Protected Overridable Sub AppendDeleteCommand(commandStringBuilder As StringBuilder, name As String, schema As String, conditionOperations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
conditionOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendDeleteCommandHeader(StringBuilder, String, String) AppendDeleteCommandHeader(StringBuilder, String, String)

protected virtual void AppendDeleteCommandHeader(StringBuilder commandStringBuilder, string name, string schema)
Protected Overridable Sub AppendDeleteCommandHeader(commandStringBuilder As StringBuilder, name As String, schema As String)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String

AppendDeleteOperation(StringBuilder, ModificationCommand, Int32) AppendDeleteOperation(StringBuilder, ModificationCommand, Int32)

public virtual ResultSetMapping AppendDeleteOperation(StringBuilder commandStringBuilder, ModificationCommand command, int commandPosition)
Public Overridable Function AppendDeleteOperation(commandStringBuilder As StringBuilder, command As ModificationCommand, commandPosition As Integer) As ResultSetMapping
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
commandPosition
System.Int32 System.Int32
Returns

AppendFromClause(StringBuilder, String, String) AppendFromClause(StringBuilder, String, String)

protected virtual void AppendFromClause(StringBuilder commandStringBuilder, string name, string schema)
Protected Overridable Sub AppendFromClause(commandStringBuilder As StringBuilder, name As String, schema As String)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String

AppendIdentityWhereCondition(StringBuilder, ColumnModification) AppendIdentityWhereCondition(StringBuilder, ColumnModification)

protected abstract void AppendIdentityWhereCondition(StringBuilder commandStringBuilder, ColumnModification columnModification)
Protected MustOverride Sub AppendIdentityWhereCondition(commandStringBuilder As StringBuilder, columnModification As ColumnModification)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder

AppendInsertCommand(StringBuilder, String, String, IReadOnlyList) AppendInsertCommand(StringBuilder, String, String, IReadOnlyList(Of ColumnModification))

protected virtual void AppendInsertCommand(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> writeOperations)
Protected Overridable Sub AppendInsertCommand(commandStringBuilder As StringBuilder, name As String, schema As String, writeOperations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
writeOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendInsertCommandHeader(StringBuilder, String, String, IReadOnlyList) AppendInsertCommandHeader(StringBuilder, String, String, IReadOnlyList(Of ColumnModification))

protected virtual void AppendInsertCommandHeader(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendInsertCommandHeader(commandStringBuilder As StringBuilder, name As String, schema As String, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendInsertOperation(StringBuilder, ModificationCommand, Int32) AppendInsertOperation(StringBuilder, ModificationCommand, Int32)

public virtual ResultSetMapping AppendInsertOperation(StringBuilder commandStringBuilder, ModificationCommand command, int commandPosition)
Public Overridable Function AppendInsertOperation(commandStringBuilder As StringBuilder, command As ModificationCommand, commandPosition As Integer) As ResultSetMapping
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
commandPosition
System.Int32 System.Int32
Returns

AppendNextSequenceValueOperation(StringBuilder, String, String) AppendNextSequenceValueOperation(StringBuilder, String, String)

public virtual void AppendNextSequenceValueOperation(StringBuilder commandStringBuilder, string name, string schema)
Public Overridable Sub AppendNextSequenceValueOperation(commandStringBuilder As StringBuilder, name As String, schema As String)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String

AppendRowsAffectedWhereCondition(StringBuilder, Int32) AppendRowsAffectedWhereCondition(StringBuilder, Int32)

protected abstract void AppendRowsAffectedWhereCondition(StringBuilder commandStringBuilder, int expectedRowsAffected)
Protected MustOverride Sub AppendRowsAffectedWhereCondition(commandStringBuilder As StringBuilder, expectedRowsAffected As Integer)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
expectedRowsAffected
System.Int32 System.Int32

AppendSelectAffectedCommand(StringBuilder, String, String, IReadOnlyList, IReadOnlyList, Int32) AppendSelectAffectedCommand(StringBuilder, String, String, IReadOnlyList(Of ColumnModification), IReadOnlyList(Of ColumnModification), Int32)

protected virtual ResultSetMapping AppendSelectAffectedCommand(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> readOperations, IReadOnlyList<ColumnModification> conditionOperations, int commandPosition)
Protected Overridable Function AppendSelectAffectedCommand(commandStringBuilder As StringBuilder, name As String, schema As String, readOperations As IReadOnlyList(Of ColumnModification), conditionOperations As IReadOnlyList(Of ColumnModification), commandPosition As Integer) As ResultSetMapping
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
readOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)
conditionOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)
commandPosition
System.Int32 System.Int32
Returns

AppendSelectAffectedCountCommand(StringBuilder, String, String, Int32) AppendSelectAffectedCountCommand(StringBuilder, String, String, Int32)

protected virtual ResultSetMapping AppendSelectAffectedCountCommand(StringBuilder commandStringBuilder, string name, string schema, int commandPosition)
Protected Overridable Function AppendSelectAffectedCountCommand(commandStringBuilder As StringBuilder, name As String, schema As String, commandPosition As Integer) As ResultSetMapping
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
commandPosition
System.Int32 System.Int32
Returns

AppendSelectCommandHeader(StringBuilder, IReadOnlyList) AppendSelectCommandHeader(StringBuilder, IReadOnlyList(Of ColumnModification))

protected virtual void AppendSelectCommandHeader(StringBuilder commandStringBuilder, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendSelectCommandHeader(commandStringBuilder As StringBuilder, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList, IReadOnlyList) AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList(Of ColumnModification), IReadOnlyList(Of ColumnModification))

protected virtual void AppendUpdateCommand(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> writeOperations, IReadOnlyList<ColumnModification> conditionOperations)
Protected Overridable Sub AppendUpdateCommand(commandStringBuilder As StringBuilder, name As String, schema As String, writeOperations As IReadOnlyList(Of ColumnModification), conditionOperations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
writeOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)
conditionOperations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendUpdateCommandHeader(StringBuilder, String, String, IReadOnlyList) AppendUpdateCommandHeader(StringBuilder, String, String, IReadOnlyList(Of ColumnModification))

protected virtual void AppendUpdateCommandHeader(StringBuilder commandStringBuilder, string name, string schema, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendUpdateCommandHeader(commandStringBuilder As StringBuilder, name As String, schema As String, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
name
System.String System.String
schema
System.String System.String
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendUpdateOperation(StringBuilder, ModificationCommand, Int32) AppendUpdateOperation(StringBuilder, ModificationCommand, Int32)

public virtual ResultSetMapping AppendUpdateOperation(StringBuilder commandStringBuilder, ModificationCommand command, int commandPosition)
Public Overridable Function AppendUpdateOperation(commandStringBuilder As StringBuilder, command As ModificationCommand, commandPosition As Integer) As ResultSetMapping
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
commandPosition
System.Int32 System.Int32
Returns

AppendValues(StringBuilder, IReadOnlyList) AppendValues(StringBuilder, IReadOnlyList(Of ColumnModification))

protected virtual void AppendValues(StringBuilder commandStringBuilder, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendValues(commandStringBuilder As StringBuilder, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendValuesHeader(StringBuilder, IReadOnlyList) AppendValuesHeader(StringBuilder, IReadOnlyList(Of ColumnModification))

protected virtual void AppendValuesHeader(StringBuilder commandStringBuilder, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendValuesHeader(commandStringBuilder As StringBuilder, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendWhereAffectedClause(StringBuilder, IReadOnlyList) AppendWhereAffectedClause(StringBuilder, IReadOnlyList(Of ColumnModification))

protected virtual void AppendWhereAffectedClause(StringBuilder commandStringBuilder, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendWhereAffectedClause(commandStringBuilder As StringBuilder, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendWhereClause(StringBuilder, IReadOnlyList) AppendWhereClause(StringBuilder, IReadOnlyList(Of ColumnModification))

protected virtual void AppendWhereClause(StringBuilder commandStringBuilder, IReadOnlyList<ColumnModification> operations)
Protected Overridable Sub AppendWhereClause(commandStringBuilder As StringBuilder, operations As IReadOnlyList(Of ColumnModification))
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
operations
System.Collections.Generic.IReadOnlyList<ColumnModification> System.Collections.Generic.IReadOnlyList(Of ColumnModification)

AppendWhereCondition(StringBuilder, ColumnModification, Boolean) AppendWhereCondition(StringBuilder, ColumnModification, Boolean)

protected virtual void AppendWhereCondition(StringBuilder commandStringBuilder, ColumnModification columnModification, bool useOriginalValue)
Protected Overridable Sub AppendWhereCondition(commandStringBuilder As StringBuilder, columnModification As ColumnModification, useOriginalValue As Boolean)
Parameters
commandStringBuilder
System.Text.StringBuilder System.Text.StringBuilder
useOriginalValue
System.Boolean System.Boolean

GenerateNextSequenceValueOperation(String, String) GenerateNextSequenceValueOperation(String, String)

public virtual string GenerateNextSequenceValueOperation(string name, string schema)
Public Overridable Function GenerateNextSequenceValueOperation(name As String, schema As String) As String
Parameters
name
System.String System.String
schema
System.String System.String
Returns
System.String System.String