Table of Contents

Class SqlServer2008SqlBuilder

Namespace
LinqToDB.Internal.DataProvider.SqlServer
Assembly
linq2db.dll
public class SqlServer2008SqlBuilder : SqlServerSqlBuilder, ISqlBuilder
Inheritance
object
SqlServer2008SqlBuilder
Implements
Inherited Members
Extension Methods

Constructors

SqlServer2008SqlBuilder(IDataProvider?, MappingSchema, DataOptions, ISqlOptimizer, SqlProviderFlags) 

public SqlServer2008SqlBuilder(IDataProvider? provider, MappingSchema mappingSchema, DataOptions dataOptions, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)

Parameters

provider IDataProvider
mappingSchema MappingSchema
dataOptions DataOptions
sqlOptimizer ISqlOptimizer
sqlProviderFlags SqlProviderFlags

Properties

Name 

public override string Name { get; }

Property Value

string

Methods

BuildDataTypeFromDataType(DbDataType, bool, bool) 

protected override void BuildDataTypeFromDataType(DbDataType type, bool forCreateTable, bool canBeNull)

Parameters

type DbDataType
forCreateTable bool
canBeNull bool

Type could store NULL values (could be used for column table type generation or for databases with explicit typee nullability like ClickHouse).

BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement) 

protected override void BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement insertOrUpdate)

Parameters

insertOrUpdate SqlInsertOrUpdateStatement

BuildMergeInto(NullabilityContext, SqlMergeStatement) 

protected override void BuildMergeInto(NullabilityContext nullability, SqlMergeStatement merge)

Parameters

nullability NullabilityContext
merge SqlMergeStatement

BuildMergeOperationDeleteBySource(NullabilityContext, SqlMergeOperationClause) 

protected override void BuildMergeOperationDeleteBySource(NullabilityContext nullability, SqlMergeOperationClause operation)

Parameters

nullability NullabilityContext
operation SqlMergeOperationClause

BuildMergeOperationUpdateBySource(NullabilityContext, SqlMergeOperationClause) 

protected override void BuildMergeOperationUpdateBySource(NullabilityContext nullability, SqlMergeOperationClause operation)

Parameters

nullability NullabilityContext
operation SqlMergeOperationClause

BuildMergeStatement(SqlMergeStatement) 

protected override void BuildMergeStatement(SqlMergeStatement merge)

Parameters

merge SqlMergeStatement

BuildMergeTerminator(NullabilityContext, SqlMergeStatement)

Allows to add text after generated merge command. E.g. to specify command terminator if provider requires it.

protected override void BuildMergeTerminator(NullabilityContext nullability, SqlMergeStatement merge)

Parameters

nullability NullabilityContext
merge SqlMergeStatement

CreateSqlBuilder() 

protected override ISqlBuilder CreateSqlBuilder()

Returns

ISqlBuilder