Public Static (Shared) Properties
  isMysqlLibraryAvailable | |
| getSoredConnectionString | Get stored connection string. |
Public Static (Shared) Methods
 getClient | Suuport for Microsoft framework, helper, require another sql query when 0 is selected |
| getMsSql | Get new client with System.Data.SqlClient database provider. |
| getMySql | Get new client with System.Data.SqlClient database provider. |
| getOdbc | Get new client with Data.Odbc database provider. |
| getOracle | Get native oracle client. |
Public Instance Constructors
|
client Constructor
|
Create new client. |
Public Instance Fields
 commandBuilderType | Type of Command Builder object for current client. |
| commandType | Type of Command object for current client. |
| connectionType | Type of Connection object for current client. |
| dataAdapterType | Type of DataAdapter object for current client. |
| isolationLevel | |
| mysqlCommand | |
| mysqlConnection | |
| mysqlDataAdapter | |
| mysqlDataReader | |
| mysqlTransaction | |
| odbcCommand | |
| odbcConnection | |
| odbcDataAdapter | |
| odbcDataReader | |
| odbcTransaction | |
| oledbCommand | |
| oledbConnection | |
| oledbDataAdapter | |
| oledbDataReader | |
| oledbTransaction | |
| oracleCommand | |
| oracleConnection | |
| oracleDataAdapter | |
| oracleDataReader | |
| oracleTransaction | |
| sqlCommand | |
| sqlConnection | |
| sqlDataAdapter | |
| sqlDataReader | |
| sqlDialect | SqlDialect object. |
| sqlTransaction |
Public Instance Properties
| Command_CommandText | CommandText for connection object. |
| Command_Connection | Connection for command object. |
| Command_Connection_State | Connection state. |
| Command_Transaction | CommandText for connection object. |
| Connection_ConnectionString | Connection string for connection object. |
| Connection_State | Connection state. |
| connectionString | Get or set connection string. |
| currentClienType | Return current clienttype |
| dataAdapter_MissingSchemaAction | Get or set MissingSchemaAction for DataAdapter |
| dataAdapter_SelectCommand | Get or set selectCommand for DataAdapter |
| genericCommand | |
| genericCommandBuilder | Get or set generic command builder. |
| genericConnection | |
| genericDataAdapter | |
| genericDataReader | |
| genericTransaction | |
| getSimpleClientType |
Public Instance Methods
| close | Close connection and release all possible resources. |
| Command_Connection_Close | Close command connection object |
| Command_Connection_Dispose | Dispose command connection object |
| Command_Dispose | Dispose command object |
| Command_ExecuteNonQuery | ExecuteNonQuery using command object |
| Command_ExecuteReader | ExecuteReader for Connection |
| Command_ExecuteScalar | ExecuteScalar using command object |
| Command_Parameters_Add | Add command parameters |
| Command_Parameters_Clear | Clear command parameters |
| commandBuilder_Dispose | Dispose commandBuilder |
| Connection_BeginTransaction | Get Schema Table using DataReader |
| Connection_Close | Close Connection |
| Connection_Dispose | Dispose Connection |
| Connection_InitializeLifetimeService | |
| Connection_Open | Open Connection |
| DataAdapter_Dispose | Dispose DataAdapter |
| DataAdapter_Fill | Fill dataset using dataAdapter |
| DataAdapter_Update | Update database table from dataset using dataAdapter |
| DataReader_Close | Close DataReader |
| DataReader_Dispose | Dispose DataReader |
| DataReader_GetSchemaTable | Get Schema Table using DataReader |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. |
| getNewCommandBuilder | Get new CommandBuilder object for current client type. |
| getNewInstance | Get new instance with settings from current client. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| isNamedParameter | Get information if client use named parameters for SQL queries. |
| setNewCommandBuilderAndDataAdapter | Set dataAdapter to New commandBuilder object |
| setToNothing | |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
| transaction_Commit | Commit transaction. |
| transaction_Rollback | Rollback transaction. |
| transactionIsConnectionNothing | Returns true if transaction connection is nothing. |
Protected Instance Methods
 Finalize | |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
client Class | Indoo.Data Namespace