Class SqlServerDataProvider

Namespace

LinqToDB.DataProvider.SqlServer

Assembly

linq2db.dll

public abstract class SqlServerDataProvider : DynamicDataProviderBase<SqlServerProviderAdapter>, IDataProvider

Inheritance

object

DataProviderBase

DynamicDataProviderBase<SqlServerProviderAdapter>

SqlServerDataProvider

Implements

IDataProvider

Inherited Members

DynamicDataProviderBase<SqlServerProviderAdapter>.GetProviderSpecificValueReaderMethod

DynamicDataProviderBase<SqlServerProviderAdapter>.Adapter

DynamicDataProviderBase<SqlServerProviderAdapter>.ConnectionNamespace

DynamicDataProviderBase<SqlServerProviderAdapter>.DataReaderType

DynamicDataProviderBase<SqlServerProviderAdapter>.TransactionsSupported

DynamicDataProviderBase<SqlServerProviderAdapter>.CreateConnectionInternal(string)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetField(Type, string, string, bool, Type)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetProviderField<TField>(string, Type)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetProviderField(Type, string, Type)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetToTypeField(Type, string, Type)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetProviderField<TTo, TField>(string, bool, Type)

DynamicDataProviderBase<SqlServerProviderAdapter>.SetProviderField(Type, Type, string, bool, Type, string)

DynamicDataProviderBase<SqlServerProviderAdapter>.TryGetProviderParameter(IDataContext, DbParameter)

DynamicDataProviderBase<SqlServerProviderAdapter>.TryGetProviderCommand(IDataContext, DbCommand)

DynamicDataProviderBase<SqlServerProviderAdapter>.TryGetProviderConnection(IDataContext, DbConnection)

DynamicDataProviderBase<SqlServerProviderAdapter>.TryGetProviderTransaction(IDataContext, DbTransaction)

DataProviderBase.Name

DataProviderBase.MappingSchema

DataProviderBase.SqlProviderFlags

DataProviderBase.OnConnectionCreated

DataProviderBase.InitContext(IDataContext)

DataProviderBase.ID

DataProviderBase.CreateConnection(string)

DataProviderBase.InitCommand(DataConnection, DbCommand, CommandType, string, DataParameter[], bool)

DataProviderBase.ClearCommandParameters(DbCommand)

DataProviderBase.DisposeCommand(DbCommand)

DataProviderBase.GetCommandBehavior(CommandBehavior)

DataProviderBase.ExecuteScope(DataConnection)

DataProviderBase.ReaderExpressions

DataProviderBase.SetCharField(string, Expression<Func<DbDataReader, int, string>>)

DataProviderBase.SetCharFieldToType<T>(string, Expression<Func<DbDataReader, int, string>>)

DataProviderBase.SetField<TP, T>(Expression<Func<TP, int, T>>)

DataProviderBase.SetField<TP, T>(string, Expression<Func<TP, int, T>>)

DataProviderBase.SetField<TP, T>(string, Type, Expression<Func<TP, int, T>>)

DataProviderBase.SetProviderField<TP, T>(Expression<Func<TP, int, T>>)

DataProviderBase.SetProviderField<TP, T, TS>(Expression<Func<TP, int, T>>)

DataProviderBase.SetToType<TP, T, TF>(Expression<Func<TP, int, T>>)

DataProviderBase.SetToType<TP, T, TF>(string, Expression<Func<TP, int, T>>)

DataProviderBase.NormalizeTypeName(string)

DataProviderBase.GetReaderExpression(DbDataReader, int, Expression, Type)

DataProviderBase.FindExpression(ReaderInfo, out Expression)

DataProviderBase.IsDBNullAllowed(DataOptions, DbDataReader, int)

DataProviderBase.ConvertParameterType(Type, DbDataType)

DataProviderBase.GetQueryParameterNormalizer()

Extension Methods

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

Constructors

SqlServerDataProvider(string, SqlServerVersion)

protected SqlServerDataProvider(string name, SqlServerVersion version)

Parameters

name string

version SqlServerVersion

SqlServerDataProvider(string, SqlServerVersion, SqlServerProvider)

protected SqlServerDataProvider(string name, SqlServerVersion version, SqlServerProvider provider)

Parameters

name string

version SqlServerVersion

provider SqlServerProvider

Properties

Provider

public SqlServerProvider Provider { get; }

Property Value

SqlServerProvider

SupportedTableOptions

public override TableOptions SupportedTableOptions { get; }

Property Value

TableOptions

Version

public SqlServerVersion Version { get; }

Property Value

SqlServerVersion

Methods

AddUdtType(Type, string)

public void AddUdtType(Type type, string udtName)

Parameters

type Type

udtName string

AddUdtType(Type, string, object?, DataType)

public void AddUdtType(Type type, string udtName, object? defaultValue, DataType dataType = DataType.Undefined)

Parameters

type Type

udtName string

defaultValue object

dataType DataType

AddUdtType<T>(string, T, DataType)

public void AddUdtType<T>(string udtName, T defaultValue, DataType dataType = DataType.Undefined)

Parameters

udtName string

defaultValue T

dataType DataType

Type Parameters

T

BulkCopyAsync<T>(DataOptions, ITable<T>, IEnumerable<T>, CancellationToken)

public override Task<BulkCopyRowsCopied> BulkCopyAsync<T>(DataOptions options, ITable<T> table, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull

Parameters

options DataOptions

table ITable<T>

source IEnumerable<T>

cancellationToken CancellationToken

Returns

Task<BulkCopyRowsCopied>

Type Parameters

T

BulkCopy<T>(DataOptions, ITable<T>, IEnumerable<T>)

public override BulkCopyRowsCopied BulkCopy<T>(DataOptions options, ITable<T> table, IEnumerable<T> source) where T : notnull

Parameters

options DataOptions

table ITable<T>

source IEnumerable<T>

Returns

BulkCopyRowsCopied

Type Parameters

T

CreateSqlBuilder(MappingSchema, DataOptions)

public override ISqlBuilder CreateSqlBuilder(MappingSchema mappingSchema, DataOptions dataOptions)

Parameters

mappingSchema MappingSchema

dataOptions DataOptions

Returns

ISqlBuilder

GetConnectionInfo(DataConnection, string)

public override object? GetConnectionInfo(DataConnection dataConnection, string parameterName)

Parameters

dataConnection DataConnection

parameterName string

Returns

object

GetSchemaProvider()

public override ISchemaProvider GetSchemaProvider()

Returns

ISchemaProvider

GetSqlOptimizer(DataOptions)

public override ISqlOptimizer GetSqlOptimizer(DataOptions dataOptions)

Parameters

dataOptions DataOptions

Returns

ISqlOptimizer

SetParameter(DataConnection, DbParameter, string, DbDataType, object?)

public override void SetParameter(DataConnection dataConnection, DbParameter parameter, string name, DbDataType dataType, object? value)

Parameters

dataConnection DataConnection

parameter DbParameter

name string

dataType DbDataType

value object

SetParameterType(DataConnection, DbParameter, DbDataType)

protected override void SetParameterType(DataConnection dataConnection, DbParameter parameter, DbDataType dataType)

Parameters

dataConnection DataConnection

parameter DbParameter

dataType DbDataType