Method | Description | |
---|---|---|
GetConnection ( string connectionString ) : IDbConnection | ||
RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable |
||
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable |
||
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable |
||
RunStoredProcedureScalar ( IDbConnection conn, string procedureName, |
Run a stored procedure, and return a single scalar value
|
Method | Description | |
---|---|---|
GetQueryForRows ( string query, int firstRow, int totalRows ) : string | ||
InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable |
public GetConnection ( string connectionString ) : IDbConnection | ||
connectionString | string | |
return | IDbConnection |
protected GetQueryForRows ( string query, int firstRow, int totalRows ) : string | ||
query | string | |
firstRow | int | |
totalRows | int | |
return | string |
protected InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable |
||
conn | IDbConnection | |
query | string | |
parameters | IEnumerable |
|
transaction | IDbTransaction | |
commandBehavior | CommandBehavior | |
return | int |
public RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable |
||
connection | IDbConnection | |
procedureName | string | |
inputParameters | IEnumerable |
|
outputParameters | IEnumerable |
|
transaction | IDbTransaction | |
commandBehavior | CommandBehavior | |
return | void |
public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable |
||
connection | IDbConnection | |
procedureName | string | |
queryParameters | IEnumerable |
|
transaction | IDbTransaction | |
commandBehavior | CommandBehavior | |
return | System.Data.SqlClient.SqlDataReader |
public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable |
||
connection | IDbConnection | |
procedureName | string | |
queryParameters | IEnumerable |
|
outputParameters | IEnumerable |
|
transaction | IDbTransaction | |
commandBehavior | CommandBehavior | |
return | System.Data.SqlClient.SqlDataReader |
public RunStoredProcedureScalar ( IDbConnection conn, string procedureName, |
||
conn | IDbConnection | |
procedureName | string | |
parameters | ||
transaction | IDbTransaction | |
commandBehavior | CommandBehavior | |
return | int |