C# 클래스 nHydrate.Generator.DatabaseHelper

Summary description for DbHelper.
파일 보기 프로젝트 열기: nHydrate/nHydrate

공개 메소드들

메소드 설명
ExecuteDataset ( string connectionString, string sql ) : DataSet
ExecuteNonQuery ( IDbCommand command ) : int
GetCommand ( string connectionString, string spName ) : IDbCommand
GetConnection ( string connectionString ) : IDbConnection
GetSQLDataType ( string sqlTypeString ) : SqlDbType
SetParameterValue ( IDbCommand command, string paramName, object inValue ) : void
TestConnectionString ( string connectString ) : bool

비공개 메소드들

메소드 설명
DatabaseHelper ( ) : System
ExecuteDataset ( string connectionString, string storedProcedureName, SqlParameter arParms ) : DataSet
ExecuteNonQuery ( string connectionString, string storedProcedureName, SqlParameter arParms ) : void
ExecuteReader ( IDbCommand selectCommand ) : System.Data.SqlClient.SqlDataReader
ExecuteReader ( IDbConnection connection, CommandType cmdType, string stmt ) : System.Data.SqlClient.SqlDataReader
ExecuteReader ( string connectString, CommandType cmdType, string stmt ) : System.Data.SqlClient.SqlDataReader
Fill ( IDbDataAdapter da, DataTable dt ) : void
GetCommand ( ) : IDbCommand
GetDataAdapter ( ) : IDbDataAdapter
GetSQLDataType ( SqlNativeTypes nativeType ) : SqlDbType
SetConnections ( IDbDataAdapter da, IDbConnection conn ) : void
SetTransaction ( IDbDataAdapter da, IDbTransaction trans ) : void
Update ( IDbDataAdapter da, DataRow rows ) : void
Update ( IDbDataAdapter da, DataTable dt ) : void

메소드 상세

ExecuteDataset() 공개 정적인 메소드

public static ExecuteDataset ( string connectionString, string sql ) : DataSet
connectionString string
sql string
리턴 System.Data.DataSet

ExecuteNonQuery() 공개 정적인 메소드

public static ExecuteNonQuery ( IDbCommand command ) : int
command IDbCommand
리턴 int

GetCommand() 공개 정적인 메소드

public static GetCommand ( string connectionString, string spName ) : IDbCommand
connectionString string
spName string
리턴 IDbCommand

GetConnection() 공개 정적인 메소드

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

GetSQLDataType() 공개 정적인 메소드

public static GetSQLDataType ( string sqlTypeString ) : SqlDbType
sqlTypeString string
리턴 SqlDbType

SetParameterValue() 공개 정적인 메소드

public static SetParameterValue ( IDbCommand command, string paramName, object inValue ) : void
command IDbCommand
paramName string
inValue object
리턴 void

TestConnectionString() 공개 정적인 메소드

public static TestConnectionString ( string connectString ) : bool
connectString string
리턴 bool