C# Class IQMap.Impl.MSSQLDataStorageController

Inheritance: SqlDataStorageController
Mostrar archivo Open project: jamietre/IQMap Class Usage Examples

Public Methods

Method Description
GetConnection ( string connectionString ) : IDbConnection
RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable inputParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : void
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : System.Data.SqlClient.SqlDataReader
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : System.Data.SqlClient.SqlDataReader
RunStoredProcedureScalar ( IDbConnection conn, string procedureName, SqlParameter parameters, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int

Run a stored procedure, and return a single scalar value

Protected Methods

Method Description
GetQueryForRows ( ISqlQuery query ) : string

Note that FirstRow is zero-indexed, so 0 means ignore (or the first row should be the usual first row).
InsertAndReturnNewID ( IDbConnection conn, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int

Method Details

GetConnection() public method

public GetConnection ( string connectionString ) : IDbConnection
connectionString string
return IDbConnection

GetQueryForRows() protected method

Note that FirstRow is zero-indexed, so 0 means ignore (or the first row should be the usual first row).
protected GetQueryForRows ( ISqlQuery query ) : string
query ISqlQuery
return string

InsertAndReturnNewID() protected method

protected InsertAndReturnNewID ( IDbConnection conn, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
query ISqlQuery
transaction IDbTransaction
commandBehavior CommandBehavior
return int

RunStoredProcedure() public method

public RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable inputParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : void
connection IDbConnection
procedureName string
inputParameters IEnumerable
outputParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
return void

RunStoredProcedureDataset() public method

public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : System.Data.SqlClient.SqlDataReader
connection IDbConnection
procedureName string
queryParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
return System.Data.SqlClient.SqlDataReader

RunStoredProcedureDataset() public method

public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : System.Data.SqlClient.SqlDataReader
connection IDbConnection
procedureName string
queryParameters IEnumerable
outputParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
return System.Data.SqlClient.SqlDataReader

RunStoredProcedureScalar() public method

Run a stored procedure, and return a single scalar value
public RunStoredProcedureScalar ( IDbConnection conn, string procedureName, SqlParameter parameters, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
procedureName string
parameters System.Data.SqlClient.SqlParameter
transaction IDbTransaction
commandBehavior CommandBehavior
return int