C# 클래스 IQMap.Implementation.SqlDataStorageController

상속: IDataStorageController
파일 보기 프로젝트 열기: jamietre/IQMap

공개 메소드들

메소드 설명
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