C# Class IQMap.Implementation.SqlDataStorageController

Inheritance: IDataStorageController

Afficher le fichier Open project: jamietre/IQMap

Méthodes publiques

Méthode	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

Méthodes protégées

Méthode	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

Méthode	Description
HasParameter ( string sql, string ParameterName ) : bool

Method Details

CleanSql() protected méthode

protected CleanSql ( string sql ) : string
sql	string
Résultat	string

Count() public méthode

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

ExecuteSqlFinal() protected méthode

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

protected ExecuteSqlFinal ( System.Action function ) : void
function	System.Action
Résultat	void

GetCommand() protected méthode

protected GetCommand ( IDbConnection connection, string query, IEnumerable parameters, IDbTransaction transaction ) : IDbCommand
connection	IDbConnection
query	string
parameters	IEnumerable
transaction	IDbTransaction
Résultat	IDbCommand

GetConnection() public abstract méthode

public abstract GetConnection ( string connectionString ) : IDbConnection
connectionString	string
Résultat	IDbConnection

GetQueryForRows() protected abstract méthode

protected abstract GetQueryForRows ( string query, int firstRow, int totalRows ) : string
query	string
firstRow	int
totalRows	int
Résultat	string

InsertAndReturnNewID() protected abstract méthode

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
Résultat	int

LastQueryAudit() public méthode

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

public LastQueryAudit ( ) : string
Résultat	string

OnQueryComplete() protected méthode

protected OnQueryComplete ( ) : void
Résultat	void

ProcessSql() protected méthode

protected ProcessSql ( string querySql, IEnumerable parameters ) : string
querySql	string
parameters	IEnumerable
Résultat	string

RunQuery() public méthode

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
Résultat	IDataReader

RunQuery() public méthode

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
Résultat	IDataReader

RunQueryInsert() public méthode

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
Résultat	int

RunQueryScalar() public méthode

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
Résultat	int

RunStoredProcedure() public méthode

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
Résultat	IDataReader

ValidateQueryType() protected méthode

protected ValidateQueryType ( string query, string match ) : void
query	string
match	string
Résultat	void