C# Class MWS.Data.DBWrapper

Summary description for DBWrapper.
Inheritance: IDisposable
Mostrar archivo Open project: Movilizer/.NET_Connector Class Usage Examples

Protected Properties

Property Type Description
m_bConnected bool
m_bDisposed bool
m_eProvider PROVIDER_TYPE
m_nCommandTimeout int
m_nRetryConnect int
m_oCommand System.Data.IDbCommand
m_oConnection System.Data.IDbConnection
m_oTransaction System.Data.IDbTransaction
m_sConnectionString string
m_sProviderAssembly string
m_sProviderCommandBuilderClass string
m_sProviderConnectionClass string

Public Methods

Method Description
AddParameter ( IDataParameter oParam ) : void
BeginTransaction ( ) : void
ClearParameters ( ) : void
CommitTransaction ( ) : void
Connect ( ) : bool
DeriveParameters ( string sStoredProcedure ) : IDataParameterCollection
DeriveParameters ( string sSql, CommandType oType ) : IDataParameterCollection
Disconnect ( ) : void
Dispose ( ) : void
ExecuteNonQuery ( string sSQL ) : object
ExecuteNonQuery ( string sSQL, CommandType oType ) : object
ExecuteReader ( string sSQL ) : IDataReader
ExecuteReader ( string sSQL, CommandType oType ) : IDataReader
ExecuteScalar ( string sSQL ) : object
ExecuteScalar ( string sSQL, CommandType oType ) : object
GetADONETWrapper ( ) : DBWrapper
GetADONETWrapper ( string sProviderName ) : DBWrapper
GetADONETWrapper ( string sProviderAssembly, string sConnectionClass, string sCommandBuilderClass ) : DBWrapper
GetDataSet ( string sSQL ) : DataSet
GetDataSet ( string sSQL, CommandType oType ) : DataSet
GetDataSet ( string sSQL, CommandType oType, DataSet oData ) : DataSet
GetDataSource ( ) : string
GetOdbcWrapper ( ) : DBWrapper
GetOleDbWrapper ( ) : DBWrapper
GetOracleWrapper ( ) : DBWrapper
GetParameters ( ) : IDataParameterCollection
GetSqlClientWrapper ( ) : DBWrapper
RollbackTransaction ( ) : void
RollbackTransaction ( bool bThrowError ) : void
ValidateConnection ( ) : bool

Protected Methods

Method Description
DBWrapper ( ) : System
Dispose ( bool bDisposing ) : void
GetADONETProviderObject ( string sAssembly, string sClass, object oArgs ) : object
GetConnection ( ) : IDbConnection
GetDataAdapter ( string sSQL ) : IDataAdapter

Method Details

AddParameter() public method

public AddParameter ( IDataParameter oParam ) : void
oParam IDataParameter
return void

BeginTransaction() public method

public BeginTransaction ( ) : void
return void

ClearParameters() public method

public ClearParameters ( ) : void
return void

CommitTransaction() public method

public CommitTransaction ( ) : void
return void

Connect() public method

public Connect ( ) : bool
return bool

DBWrapper() protected method

protected DBWrapper ( ) : System
return System

DeriveParameters() public method

public DeriveParameters ( string sStoredProcedure ) : IDataParameterCollection
sStoredProcedure string
return IDataParameterCollection

DeriveParameters() public method

public DeriveParameters ( string sSql, CommandType oType ) : IDataParameterCollection
sSql string
oType CommandType
return IDataParameterCollection

Disconnect() public method

public Disconnect ( ) : void
return void

Dispose() public method

public Dispose ( ) : void
return void

Dispose() protected method

protected Dispose ( bool bDisposing ) : void
bDisposing bool
return void

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sSQL ) : object
sSQL string
return object

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sSQL, CommandType oType ) : object
sSQL string
oType CommandType
return object

ExecuteReader() public method

public ExecuteReader ( string sSQL ) : IDataReader
sSQL string
return IDataReader

ExecuteReader() public method

public ExecuteReader ( string sSQL, CommandType oType ) : IDataReader
sSQL string
oType CommandType
return IDataReader

ExecuteScalar() public method

public ExecuteScalar ( string sSQL ) : object
sSQL string
return object

ExecuteScalar() public method

public ExecuteScalar ( string sSQL, CommandType oType ) : object
sSQL string
oType CommandType
return object

GetADONETProviderObject() protected method

protected GetADONETProviderObject ( string sAssembly, string sClass, object oArgs ) : object
sAssembly string
sClass string
oArgs object
return object

GetADONETWrapper() public static method

public static GetADONETWrapper ( ) : DBWrapper
return DBWrapper

GetADONETWrapper() public static method

public static GetADONETWrapper ( string sProviderName ) : DBWrapper
sProviderName string
return DBWrapper

GetADONETWrapper() public static method

public static GetADONETWrapper ( string sProviderAssembly, string sConnectionClass, string sCommandBuilderClass ) : DBWrapper
sProviderAssembly string
sConnectionClass string
sCommandBuilderClass string
return DBWrapper

GetConnection() protected method

protected GetConnection ( ) : IDbConnection
return IDbConnection

GetDataAdapter() protected method

protected GetDataAdapter ( string sSQL ) : IDataAdapter
sSQL string
return IDataAdapter

GetDataSet() public method

public GetDataSet ( string sSQL ) : DataSet
sSQL string
return System.Data.DataSet

GetDataSet() public method

public GetDataSet ( string sSQL, CommandType oType ) : DataSet
sSQL string
oType CommandType
return System.Data.DataSet

GetDataSet() public method

public GetDataSet ( string sSQL, CommandType oType, DataSet oData ) : DataSet
sSQL string
oType CommandType
oData System.Data.DataSet
return System.Data.DataSet

GetDataSource() public method

public GetDataSource ( ) : string
return string

GetOdbcWrapper() public static method

public static GetOdbcWrapper ( ) : DBWrapper
return DBWrapper

GetOleDbWrapper() public static method

public static GetOleDbWrapper ( ) : DBWrapper
return DBWrapper

GetOracleWrapper() public static method

public static GetOracleWrapper ( ) : DBWrapper
return DBWrapper

GetParameters() public method

public GetParameters ( ) : IDataParameterCollection
return IDataParameterCollection

GetSqlClientWrapper() public static method

public static GetSqlClientWrapper ( ) : DBWrapper
return DBWrapper

RollbackTransaction() public method

public RollbackTransaction ( ) : void
return void

RollbackTransaction() public method

public RollbackTransaction ( bool bThrowError ) : void
bThrowError bool
return void

ValidateConnection() public method

public ValidateConnection ( ) : bool
return bool

Property Details

m_bConnected protected_oe property

protected bool m_bConnected
return bool

m_bDisposed protected_oe property

protected bool m_bDisposed
return bool

m_eProvider protected_oe property

protected PROVIDER_TYPE m_eProvider
return PROVIDER_TYPE

m_nCommandTimeout protected_oe property

protected int m_nCommandTimeout
return int

m_nRetryConnect protected_oe property

protected int m_nRetryConnect
return int

m_oCommand protected_oe property

protected IDbCommand,System.Data m_oCommand
return System.Data.IDbCommand

m_oConnection protected_oe property

protected IDbConnection,System.Data m_oConnection
return System.Data.IDbConnection

m_oTransaction protected_oe property

protected IDbTransaction,System.Data m_oTransaction
return System.Data.IDbTransaction

m_sConnectionString protected_oe property

protected string m_sConnectionString
return string

m_sProviderAssembly protected_oe property

protected string m_sProviderAssembly
return string

m_sProviderCommandBuilderClass protected_oe property

protected string m_sProviderCommandBuilderClass
return string

m_sProviderConnectionClass protected_oe property

protected string m_sProviderConnectionClass
return string