Method CreateCommand

Namespace

Open.Database.Extensions

Assembly

Open.Database.Extensions.MSSqlClient.dll

CreateCommand(SqlTransaction, CommandType, string, int)

Creates a SqlCommand enlisted in a transaction, on the transaction's connection, with the command type, text, and timeout already set.

public static SqlCommand CreateCommand(this SqlTransaction transaction, CommandType type, string commandText, int secondsTimeout = 60)

Parameters

transaction SqlTransaction

The transaction to create the command from.

type CommandType

The command type: Text, StoredProcedure, or TableDirect.

commandText string

The command text, or the stored procedure name when type is StoredProcedure.

secondsTimeout int

The number of seconds to wait before the command times out. The default is 60 seconds.

Returns

SqlCommand

A new SqlCommand that the caller owns and disposes.

Exceptions

ArgumentNullException

transaction or commandText is null.

ArgumentException

commandText is empty or white space.