Table of Contents

Method CreateTextCommand

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

CreateTextCommand(SqlConnection, string, int)

Creates a text SqlCommand from a connection.

public static SqlCommand CreateTextCommand(this SqlConnection connection, string commandText, int secondsTimeout = 60)

Parameters

connection SqlConnection

The connection to create the command from.

commandText string

The command text to use.

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. It is not associated with a transaction.

Exceptions

ArgumentNullException

connection or commandText is null.

ArgumentException

commandText is empty or white space.