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

Наследование: IDataStorageController

Показать файл Открыть проект

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

Метод	Описание
Count ( IDbConnection connection, string query, IEnumerable parameters = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
GetConnection ( string connectionString ) : IDbConnection
LastQueryAudit ( ) : string	Only works for MSSQL - trys to map the query replacing parameter values with actual values
RunQuery ( IDbConnection connection, string query, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
RunQuery ( IDbConnection connection, string query, int &rows, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
RunQueryInsert ( IDbConnection connection, string query, IEnumerable queryParameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
RunQueryScalar ( IDbConnection connection, string query, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
RunStoredProcedure ( IDbConnection connection, string spName, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader

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

Метод	Описание
CleanSql ( string sql ) : string
ExecuteSqlFinal ( System.Action function ) : void	This wraps all SQL database calls so that descendant objects can override it
GetCommand ( IDbConnection connection, string query, IEnumerable parameters, IDbTransaction transaction ) : IDbCommand
GetQueryForRows ( string query, int firstRow, int totalRows ) : string
InsertAndReturnNewID ( IDbConnection conn, string sql, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
OnQueryComplete ( ) : void
ProcessSql ( string querySql, IEnumerable parameters ) : string
ValidateQueryType ( string query, string match ) : void

Приватные методы

Метод	Описание
HasParameter ( string sql, string ParameterName ) : bool

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

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

protected CleanSql ( string sql ) : string
sql	string
Результат	string

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

public Count ( IDbConnection connection, string query, IEnumerable parameters = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	string
parameters	IEnumerable
commandBehavior	CommandBehavior
Результат	int

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

This wraps all SQL database calls so that descendant objects can override it

protected ExecuteSqlFinal ( System.Action function ) : void
function	System.Action
Результат	void

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

protected GetCommand ( IDbConnection connection, string query, IEnumerable parameters, IDbTransaction transaction ) : IDbCommand
connection	IDbConnection
query	string
parameters	IEnumerable
transaction	IDbTransaction
Результат	IDbCommand

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

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

GetQueryForRows() защищенный абстрактный Метод

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

InsertAndReturnNewID() защищенный абстрактный Метод

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

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

Only works for MSSQL - trys to map the query replacing parameter values with actual values

public LastQueryAudit ( ) : string
Результат	string

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

protected OnQueryComplete ( ) : void
Результат	void

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

protected ProcessSql ( string querySql, IEnumerable parameters ) : string
querySql	string
parameters	IEnumerable
Результат	string

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

public RunQuery ( IDbConnection connection, string query, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection	IDbConnection
query	string
parameters	IEnumerable
firstRow	int
totalRows	int
transaction	IDbTransaction
commandBehavior	CommandBehavior
Результат	IDataReader

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

public RunQuery ( IDbConnection connection, string query, int &rows, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection	IDbConnection
query	string
rows	int
parameters	IEnumerable
firstRow	int
totalRows	int
transaction	IDbTransaction
commandBehavior	CommandBehavior
Результат	IDataReader

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

public RunQueryInsert ( IDbConnection connection, string query, IEnumerable queryParameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	string
queryParameters	IEnumerable
transaction	IDbTransaction
commandBehavior	CommandBehavior
Результат	int

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

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

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

public RunStoredProcedure ( IDbConnection connection, string spName, IEnumerable parameters = null, int firstRow = -1, int totalRows = -1, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection	IDbConnection
spName	string
parameters	IEnumerable
firstRow	int
totalRows	int
transaction	IDbTransaction
commandBehavior	CommandBehavior
Результат	IDataReader

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

protected ValidateQueryType ( string query, string match ) : void
query	string
match	string
Результат	void