Table of Contents

Class DB2LUWSqlBuilder

Namespace
LinqToDB.Internal.DataProvider.DB2
Assembly
linq2db.dll
public class DB2LUWSqlBuilder : DB2SqlBuilderBase, ISqlBuilder
Inheritance
object
DB2LUWSqlBuilder
Implements
Inherited Members
Extension Methods

Constructors

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

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

Parameters

provider IDataProvider
mappingSchema MappingSchema
dataOptions DataOptions
sqlOptimizer ISqlOptimizer
sqlProviderFlags SqlProviderFlags

Properties

Version 

protected override DB2Version Version { get; }

Property Value

DB2Version

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

BuildObjectName(StringBuilder, SqlObjectName, ConvertType, bool, TableOptions, bool)

Writes database object name into provided StringBuilder instance.

public override StringBuilder BuildObjectName(StringBuilder sb, SqlObjectName name, ConvertType objectType = ConvertType.NameToQueryTable, bool escape = true, TableOptions tableOptions = TableOptions.NotSet, bool withoutSuffix = false)

Parameters

sb StringBuilder

String builder for generated object name.

name SqlObjectName

Name of database object (e.g. table, view, procedure or function).

objectType ConvertType

Type of database object, used to select proper name converter.

escape bool

If true, apply required escaping to name components. Must be true except rare cases when escaping is not needed.

tableOptions TableOptions

Table options if called for table. Used to properly generate names for temporary tables.

withoutSuffix bool

If object name have suffix, which could be detached from main name, this parameter disables suffix generation (enables generation of only main name part).

Returns

StringBuilder

sb parameter value.

CreateSqlBuilder() 

protected override ISqlBuilder CreateSqlBuilder()

Returns

ISqlBuilder

GetPhysicalTableName(ISqlTableSource, string?, bool, string?, bool) 

protected override string GetPhysicalTableName(ISqlTableSource table, string? alias, bool ignoreTableExpression = false, string? defaultDatabaseName = null, bool withoutSuffix = false)

Parameters

table ISqlTableSource
alias string
ignoreTableExpression bool
defaultDatabaseName string
withoutSuffix bool

Returns

string