Table of Contents

Class SqlConnectionExtensions

Namespace
Open.Database.Extensions
Assembly
Open.Database.Extensions.MSSqlClient.dll

Extensions for SqlConnections.

public static class SqlConnectionExtensions
Inheritance
SqlConnectionExtensions
Inherited Members

Methods

Command(SqlConnection, string, CommandType)

Creates an ExpressiveSqlCommand that executes on the given connection.

Command(SqlTransaction, string, CommandType)

Creates an ExpressiveSqlCommand that executes within the given transaction.

Command(IDbConnectionFactory<SqlConnection>, string, CommandType)

Creates an ExpressiveSqlCommand that creates a new connection from a connection factory for every execution.

Command(IDbConnectionPool<SqlConnection>, string, CommandType)

Creates an ExpressiveSqlCommand that takes its connections from a connection pool.

Command(Func<SqlConnection>, string, CommandType)

Creates an ExpressiveSqlCommand that invokes a function to create a new connection for every execution.

CreateCommand(SqlConnection, CommandType, string, int)

Creates a SqlCommand from a connection with the command type, text, and timeout already set.

CreateStoredProcedureCommand(SqlConnection, string, int)

Creates a stored procedure SqlCommand from a connection.

CreateTextCommand(SqlConnection, string, int)

Creates a text SqlCommand from a connection.

StoredProcedure(SqlConnection, string)

Creates an ExpressiveSqlCommand that calls a stored procedure on the given connection.

StoredProcedure(SqlTransaction, string)

Creates an ExpressiveSqlCommand that calls a stored procedure within the given transaction.

StoredProcedure(IDbConnectionFactory<SqlConnection>, string)

Creates an ExpressiveSqlCommand that calls a stored procedure, that creates a new connection from a connection factory for every execution.

StoredProcedure(IDbConnectionPool<SqlConnection>, string)

Creates an ExpressiveSqlCommand that calls a stored procedure, that takes its connections from a connection pool.

StoredProcedure(Func<SqlConnection>, string)

Creates an ExpressiveSqlCommand that calls a stored procedure, that invokes a function to create a new connection for every execution.