C# 클래스 IQMap.Implementation.MSSQLDataStorageController

상속: SqlDataStorageController
파일 보기 프로젝트 열기: jamietre/IQMap 1 사용 예제들

공개 메소드들

메소드 설명
GetConnection ( string connectionString ) : IDbConnection
RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable inputParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : void
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : System.Data.SqlClient.SqlDataReader
RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : System.Data.SqlClient.SqlDataReader
RunStoredProcedureScalar ( IDbConnection conn, string procedureName, SqlParameter parameters, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int

Run a stored procedure, and return a single scalar value

보호된 메소드들

메소드 설명
GetQueryForRows ( string query, int firstRow, int totalRows ) : string
InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int

메소드 상세

GetConnection() 공개 메소드

public GetConnection ( string connectionString ) : IDbConnection
connectionString string
리턴 IDbConnection

GetQueryForRows() 보호된 메소드

protected GetQueryForRows ( string query, int firstRow, int totalRows ) : string
query string
firstRow int
totalRows int
리턴 string

InsertAndReturnNewID() 보호된 메소드

protected InsertAndReturnNewID ( IDbConnection conn, string query, IEnumerable parameters = null, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
query string
parameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
리턴 int

RunStoredProcedure() 공개 메소드

public RunStoredProcedure ( IDbConnection connection, string procedureName, IEnumerable inputParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : void
connection IDbConnection
procedureName string
inputParameters IEnumerable
outputParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
리턴 void

RunStoredProcedureDataset() 공개 메소드

public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IDbTransaction transaction, CommandBehavior commandBehavior ) : System.Data.SqlClient.SqlDataReader
connection IDbConnection
procedureName string
queryParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
리턴 System.Data.SqlClient.SqlDataReader

RunStoredProcedureDataset() 공개 메소드

public RunStoredProcedureDataset ( IDbConnection connection, string procedureName, IEnumerable queryParameters, IEnumerable outputParameters, IDbTransaction transaction, CommandBehavior commandBehavior = CommandBehavior.Default ) : System.Data.SqlClient.SqlDataReader
connection IDbConnection
procedureName string
queryParameters IEnumerable
outputParameters IEnumerable
transaction IDbTransaction
commandBehavior CommandBehavior
리턴 System.Data.SqlClient.SqlDataReader

RunStoredProcedureScalar() 공개 메소드

Run a stored procedure, and return a single scalar value
public RunStoredProcedureScalar ( IDbConnection conn, string procedureName, SqlParameter parameters, IDbTransaction transaction = null, CommandBehavior commandBehavior = CommandBehavior.Default ) : int
conn IDbConnection
procedureName string
parameters System.Data.SqlClient.SqlParameter
transaction IDbTransaction
commandBehavior CommandBehavior
리턴 int