C# Class Dibware.StoredProcedureFramework.Helpers.SqlTableFunctionDbCommandCreator

Inheritance: Dibware.StoredProcedureFramework.Helpers.Base.SqlFunctionDbCommandCreatorBase
Show file Open project: dibley1973/StoredProcedureFramework Class Usage Examples

Public Methods

Method Description
BuildCommand ( ) : SqlTableFunctionDbCommandCreator

Builds and sets up the command based upon the settings that have been previously passed to this builder.

Should call into base implementation before executing any addtional code

CreateSqlTableFunctionDbCommandCreator ( IDbConnection connection, string procedureName ) : SqlTableFunctionDbCommandCreator

Creates the stored procedure database command creator.

WithCommandTimeout ( int commandTimeout ) : SqlTableFunctionDbCommandCreator

Adds a command timeout to the builder which will be passed to the command when it is construted.

WithParameters ( IEnumerable parameters ) : SqlTableFunctionDbCommandCreator

Adds the specified parameters to the builder, and these will be added to the command when it is built.

Private Methods

Method Description
SqlTableFunctionDbCommandCreator ( IDbConnection connection ) : System
WithCommandText ( string commandText ) : SqlTableFunctionDbCommandCreator
WithCommandType ( CommandType commandType ) : SqlTableFunctionDbCommandCreator

Method Details

BuildCommand() public method

Builds and sets up the command based upon the settings that have been previously passed to this builder.
Should call into base implementation before executing any addtional code
public BuildCommand ( ) : SqlTableFunctionDbCommandCreator
return SqlTableFunctionDbCommandCreator

CreateSqlTableFunctionDbCommandCreator() public static method

Creates the stored procedure database command creator.
/// connection /// or /// procedureName ///
public static CreateSqlTableFunctionDbCommandCreator ( IDbConnection connection, string procedureName ) : SqlTableFunctionDbCommandCreator
connection IDbConnection /// The connection to be passed to the command when it is constructed. ///
procedureName string /// The name of the stored procedure for which the commmand is to call. ///
return SqlTableFunctionDbCommandCreator

WithCommandTimeout() public method

Adds a command timeout to the builder which will be passed to the command when it is construted.
public WithCommandTimeout ( int commandTimeout ) : SqlTableFunctionDbCommandCreator
commandTimeout int The value of the command timeout.
return SqlTableFunctionDbCommandCreator

WithParameters() public method

Adds the specified parameters to the builder, and these will be added to the command when it is built.
public WithParameters ( IEnumerable parameters ) : SqlTableFunctionDbCommandCreator
parameters IEnumerable The parameters to add to the command.
return SqlTableFunctionDbCommandCreator