C# Класс IQMap.Impl.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 ( 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

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

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

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

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

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

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

protected InsertAndReturnNewID ( IDbConnection conn, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
query ISqlQuery
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