C# Class IQMap.Implementation.SqlDataStorageController

Inheritance: IDataStorageController

ファイルを表示 Open project: jamietre/IQMap

Public Methods

Method	Description
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

Protected Methods

Method	Description
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

Private Methods

Method	Description
HasParameter ( string sql, string ParameterName ) : bool

Method Details

CleanSql() protected method

protected CleanSql ( string sql ) : string
sql	string
return	string

Count() public method

public Count ( IDbConnection connection, string query, IEnumerable parameters = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	string
parameters	IEnumerable
commandBehavior	CommandBehavior
return	int

ExecuteSqlFinal() protected method

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

protected ExecuteSqlFinal ( System.Action function ) : void
function	System.Action
return	void

GetCommand() protected method

protected GetCommand ( IDbConnection connection, string query, IEnumerable parameters, IDbTransaction transaction ) : IDbCommand
connection	IDbConnection
query	string
parameters	IEnumerable
transaction	IDbTransaction
return	IDbCommand

GetConnection() public abstract method

public abstract GetConnection ( string connectionString ) : IDbConnection
connectionString	string
return	IDbConnection

GetQueryForRows() protected abstract method

protected abstract GetQueryForRows ( string query, int firstRow, int totalRows ) : string
query	string
firstRow	int
totalRows	int
return	string

InsertAndReturnNewID() protected abstract method

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
return	int

LastQueryAudit() public method

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

public LastQueryAudit ( ) : string
return	string

OnQueryComplete() protected method

protected OnQueryComplete ( ) : void
return	void

ProcessSql() protected method

protected ProcessSql ( string querySql, IEnumerable parameters ) : string
querySql	string
parameters	IEnumerable
return	string

RunQuery() public method

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
return	IDataReader

RunQuery() public method

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
return	IDataReader

RunQueryInsert() public method

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
return	int

RunQueryScalar() public method

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
return	int

RunStoredProcedure() public method

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
return	IDataReader

ValidateQueryType() protected method

protected ValidateQueryType ( string query, string match ) : void
query	string
match	string
return	void