Class SqlServerQueryProvider

Provider, which know execute query for Sql Server.

Inheritance

System.Object

QueryProvider

SqlServerQueryProvider

Implements

IQueryProvider

Inherited Members

QueryProvider.SupportsPrepareCommand()

QueryProvider.SupportsIdentity()

QueryProvider.SetParameterDbType(DbParameter, String, String)

QueryProvider.Execute<T>(IQuery<T>)

QueryProvider.ExecuteScalar<T>(IQuery<T>)

QueryProvider.ExecuteScalarCommand(IDbCommand)

QueryProvider.ExecuteScalarCommandAsync(DbCommand, CancellationToken)

QueryProvider.ExecuteInTransactionAsync(Func<Task>)

QueryProvider.ExecuteNonQueryCommand(IDbCommand)

QueryProvider.ExecuteNonQueryCommandAsync(DbCommand, CancellationToken)

QueryProvider.ExecuteNonQuery(String)

QueryProvider.ExecuteNonQuery(String, CommandParameterCollection)

QueryProvider.ExecuteNonQueryAsync(String, CancellationToken)

QueryProvider.ExecuteNonQueryAsync(String, CancellationToken, Object[])

QueryProvider.ExecuteNonQueryAsync(String, CommandParameterCollection, CancellationToken)

QueryProvider.ExecuteStoredProcedure<TResult>(String)

QueryProvider.ExecuteStoredProcedure<TResult>(String, CommandParameterCollection)

QueryProvider.GetCommandForCurrentTransaction()

QueryProvider.BeginTransaction(IsolationLevel)

QueryProvider.CreateIdGenerator(String, Int32)

QueryProvider.GetExpressionVisitor()

QueryProvider.CreateQuery(Expression)

QueryProvider.CreateQuery<TElement>(Expression)

QueryProvider.Execute(Expression)

QueryProvider.Execute<TResult>(Expression)

QueryProvider.GetCurrentTransaction()

QueryProvider.ConnectionString

QueryProvider.IsExternalConnection

QueryProvider.Connection

QueryProvider.SetQueryFilter<T>(IQuery<T>, ISqlExpressionVisitor)

QueryProvider.Dispose(Boolean)

QueryProvider.Dispose()

Namespace: Kros.KORM.Query

Assembly: Kros.KORM.dll

Syntax

public class SqlServerQueryProvider : QueryProvider, IQueryProvider, IQueryProvider, IDisposable

Constructors

SqlServerQueryProvider(KormConnectionSettings, ISqlExpressionVisitorFactory, IModelBuilder, ILogger, IDatabaseMapper)

Initializes a new instance of the SqlServerQueryProvider class.

Declaration

public SqlServerQueryProvider(KormConnectionSettings connectionString, ISqlExpressionVisitorFactory sqlGeneratorFactory, IModelBuilder modelBuilder, ILogger logger, IDatabaseMapper databaseMapper)

Parameters

Type	Name	Description
KormConnectionSettings	connectionString	The connection string settings.
ISqlExpressionVisitorFactory	sqlGeneratorFactory	The SQL generator factory.
IModelBuilder	modelBuilder	The model builder.
ILogger	logger	The logger.
IDatabaseMapper	databaseMapper	The Database mapper.

SqlServerQueryProvider(DbConnection, ISqlExpressionVisitorFactory, IModelBuilder, ILogger, IDatabaseMapper)

Initializes a new instance of the QueryProvider class.

Declaration

public SqlServerQueryProvider(DbConnection connection, ISqlExpressionVisitorFactory sqlGeneratorFactory, IModelBuilder modelBuilder, ILogger logger, IDatabaseMapper databaseMapper)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection	The connection.
ISqlExpressionVisitorFactory	sqlGeneratorFactory	The SQL generator factory.
IModelBuilder	modelBuilder	The model builder.
ILogger	logger	The logger.
IDatabaseMapper	databaseMapper	The Database mapper.

Properties

DbProviderFactory

Returns DbProviderFactory for current provider.

Declaration

public override DbProviderFactory DbProviderFactory { get; }

Property Value

Type	Description
System.Data.Common.DbProviderFactory

Overrides

QueryProvider.DbProviderFactory

Methods

CreateBulkInsert()

Creates instance of Kros.Data.BulkActions.IBulkInsert.

Declaration

public override IBulkInsert CreateBulkInsert()

Returns

Type	Description
Kros.Data.BulkActions.IBulkInsert	Instance of Kros.Data.BulkActions.IBulkInsert.

Overrides

QueryProvider.CreateBulkInsert()

CreateBulkUpdate()

Creates instance of Kros.Data.BulkActions.IBulkUpdate.

Declaration

public override IBulkUpdate CreateBulkUpdate()

Returns

Type	Description
Kros.Data.BulkActions.IBulkUpdate	Instance of Kros.Data.BulkActions.IBulkUpdate.

Overrides

QueryProvider.CreateBulkUpdate()

GetSchemaLoader()

Returns instance of Kros.Data.Schema.SqlServer.SqlServerSchemaLoader.

Declaration

protected override IDatabaseSchemaLoader GetSchemaLoader()

Returns

Type	Description
Kros.Data.Schema.IDatabaseSchemaLoader

Overrides

QueryProvider.GetSchemaLoader()

Implements

IQueryProvider

See Also

QueryProvider