C# Class nHydrate.Generator.DatabaseHelper

Summary description for DbHelper.

Show file Open project: nHydrate/nHydrate

Public Methods

Method	Description
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

Private Methods

Method	Description
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

Method Details

ExecuteDataset() public static method

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

ExecuteNonQuery() public static method

public static ExecuteNonQuery ( IDbCommand command ) : int
command	IDbCommand
return	int

GetCommand() public static method

public static GetCommand ( string connectionString, string spName ) : IDbCommand
connectionString	string
spName	string
return	IDbCommand

GetConnection() public static method

public static GetConnection ( string connectionString ) : IDbConnection
connectionString	string
return	IDbConnection

GetSQLDataType() public static method

public static GetSQLDataType ( string sqlTypeString ) : SqlDbType
sqlTypeString	string
return	SqlDbType

SetParameterValue() public static method

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

TestConnectionString() public static method

public static TestConnectionString ( string connectString ) : bool
connectString	string
return	bool