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

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

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

Метод Описание
Count ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
GetConnection ( string connectionString ) : IDbConnection
GetQueryType ( string query ) : string

return the first word, basically
LastQueryAudit ( ) : string

Only works for MSSQL - trys to map the query replacing parameter values with actual values
RunQuery ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
RunQuery ( IDbConnection connection, ISqlQuery query, int &rows, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
RunQueryInsert ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
RunQueryScalar ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
RunStoredProcedure ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader

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

Метод Описание
BeforeRunQuery ( ISqlQuery query ) : void

Occurs right before any query is run
CleanSql ( string sql ) : string
ClearCacheAfterChange ( ISqlQuery query ) : void
Count ( IDbConnection connection, string tableName, string where, IEnumerable parameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
ExecuteSqlFinal ( System.Action function ) : void

This wraps all SQL database calls so that descendant objects can override it
GetCommand ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction ) : IDbCommand
GetQueryForRows ( ISqlQuery query ) : string
InsertAndReturnNewID ( IDbConnection conn, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
OnMapParameter ( IDataParameter input, IDataParameter output ) : void
OnQueryComplete ( ) : void
ProcessSql ( string querySql, IEnumerable parameters ) : string
ValidateQueryType ( string query, string match ) : void

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

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

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

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

Occurs right before any query is run
protected BeforeRunQuery ( ISqlQuery query ) : void
query ISqlQuery
Результат void

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

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

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

protected ClearCacheAfterChange ( ISqlQuery query ) : void
query ISqlQuery
Результат void

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

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

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

protected Count ( IDbConnection connection, string tableName, string where, IEnumerable parameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection IDbConnection
tableName string
where string
parameters IEnumerable
transaction IDbTransaction
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, ISqlQuery query, IDbTransaction transaction ) : IDbCommand
connection IDbConnection
query ISqlQuery
transaction IDbTransaction
Результат IDbCommand

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

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

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

protected abstract GetQueryForRows ( ISqlQuery query ) : string
query ISqlQuery
Результат string

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

return the first word, basically
public GetQueryType ( string query ) : string
query string
Результат string

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

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

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

protected OnMapParameter ( IDataParameter input, IDataParameter output ) : void
input IDataParameter
output IDataParameter
Результат void

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

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

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

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

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

public RunQuery ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection IDbConnection
query ISqlQuery
transaction IDbTransaction
commandBehavior CommandBehavior
Результат IDataReader

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

public RunQuery ( IDbConnection connection, ISqlQuery query, int &rows, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection IDbConnection
query ISqlQuery
rows int
transaction IDbTransaction
commandBehavior CommandBehavior
Результат IDataReader

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

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

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

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

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

public RunStoredProcedure ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection IDbConnection
query ISqlQuery
transaction IDbTransaction
commandBehavior CommandBehavior
Результат IDataReader

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

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