C# Class IQMap.Impl.SqlDataStorageController

Inheritance: IDataStorageController

Afficher le fichier Open project: jamietre/IQMap

Méthodes publiques

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

Méthodes protégées

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

Private Methods

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

Method Details

BeforeRunQuery() protected méthode

Occurs right before any query is run

protected BeforeRunQuery ( ISqlQuery query ) : void
query	ISqlQuery
Résultat	void

CleanSql() protected méthode

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

ClearCacheAfterChange() protected méthode

protected ClearCacheAfterChange ( ISqlQuery query ) : void
query	ISqlQuery
Résultat	void

Count() public méthode

public Count ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	ISqlQuery
transaction	IDbTransaction
commandBehavior	CommandBehavior
Résultat	int

Count() protected méthode

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
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, ISqlQuery query, IDbTransaction transaction ) : IDbCommand
connection	IDbConnection
query	ISqlQuery
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 ( ISqlQuery query ) : string
query	ISqlQuery
Résultat	string

GetQueryType() public méthode

return the first word, basically

public GetQueryType ( string query ) : string
query	string
Résultat	string

InsertAndReturnNewID() protected abstract méthode

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

OnMapParameter() protected méthode

protected OnMapParameter ( IDataParameter input, IDataParameter output ) : void
input	IDataParameter
output	IDataParameter
Résultat	void

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, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection	IDbConnection
query	ISqlQuery
transaction	IDbTransaction
commandBehavior	CommandBehavior
Résultat	IDataReader

RunQuery() public méthode

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

RunQueryInsert() public méthode

public RunQueryInsert ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	ISqlQuery
transaction	IDbTransaction
commandBehavior	CommandBehavior
Résultat	int

RunQueryScalar() public méthode

public RunQueryScalar ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
connection	IDbConnection
query	ISqlQuery
transaction	IDbTransaction
commandBehavior	CommandBehavior
Résultat	int

RunStoredProcedure() public méthode

public RunStoredProcedure ( IDbConnection connection, ISqlQuery query, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : IDataReader
connection	IDbConnection
query	ISqlQuery
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