C# Class IQMap.Impl.MSSQLDataStorageController

Inheritance: SqlDataStorageController
Afficher le fichier Open project: jamietre/IQMap Class Usage Examples

Méthodes publiques

Méthode 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

Méthodes protégées

Méthode 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 méthode

public GetConnection ( string connectionString ) : IDbConnection
connectionString string
Résultat IDbConnection

GetQueryForRows() protected méthode

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
Résultat string

InsertAndReturnNewID() protected méthode

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

RunStoredProcedure() public méthode

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
Résultat void

RunStoredProcedureDataset() public méthode

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
Résultat System.Data.SqlClient.SqlDataReader

RunStoredProcedureDataset() public méthode

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
Résultat System.Data.SqlClient.SqlDataReader

RunStoredProcedureScalar() public méthode

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
Résultat int