C# Class nHydrate.Generator.DatabaseHelper

Summary description for DbHelper.

Afficher le fichier Open project: nHydrate/nHydrate

Méthodes publiques

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

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

public static ExecuteDataset ( string connectionString, string sql ) : DataSet
connectionString	string
sql	string
Résultat	System.Data.DataSet

ExecuteNonQuery() public static méthode

public static ExecuteNonQuery ( IDbCommand command ) : int
command	IDbCommand
Résultat	int

GetCommand() public static méthode

public static GetCommand ( string connectionString, string spName ) : IDbCommand
connectionString	string
spName	string
Résultat	IDbCommand

GetConnection() public static méthode

public static GetConnection ( string connectionString ) : IDbConnection
connectionString	string
Résultat	IDbConnection

GetSQLDataType() public static méthode

public static GetSQLDataType ( string sqlTypeString ) : SqlDbType
sqlTypeString	string
Résultat	SqlDbType

SetParameterValue() public static méthode

public static SetParameterValue ( IDbCommand command, string paramName, object inValue ) : void
command	IDbCommand
paramName	string
inValue	object
Résultat	void

TestConnectionString() public static méthode

public static TestConnectionString ( string connectString ) : bool
connectString	string
Résultat	bool