C# Класс IQMap.Implementation.MSSQLDataStorageController

Наследование: SqlDataStorageController
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
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

Защищенные методы

Метод Описание
GetQueryForRows ( string query, int firstRow, int totalRows ) : string
InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int

Описание методов

GetConnection() публичный Метод

public GetConnection ( string connectionString ) : IDbConnection
connectionString string
Результат IDbConnection

GetQueryForRows() защищенный Метод

protected GetQueryForRows ( string query, int firstRow, int totalRows ) : string
query string
firstRow int
totalRows int
Результат string

InsertAndReturnNewID() защищенный Метод

protected InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
query string
parameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
Результат int

RunStoredProcedure() публичный Метод

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
Результат void

RunStoredProcedureDataset() публичный Метод

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
Результат System.Data.SqlClient.SqlDataReader

RunStoredProcedureDataset() публичный Метод

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
Результат System.Data.SqlClient.SqlDataReader

RunStoredProcedureScalar() публичный Метод

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
Результат int