Public Static (Shared) Fields
  showExtendedErrorDescription | When set to true some sensitive data may appear. Only for debugging/developing. |
Public Instance Constructors
dataAccess Constructor
|
Create new dataAccess object. |
Public Instance Fields
| alternativeUpdate | If there are problems with some odbc drivers, here is alternative method to update data... |
| client | Database client. |
| convertNothingToDBNullOnUpdate | Convert nothing object to dbNull when update. Default is true |
| defaultDataset | When updateRecord is used with retrieved last inserted ID, this sql statement is used" |
| store | Store results into this object and use it as custom cache for fast retrieving database data. |
Public Instance Properties
 getSqlStatementDelimiter | Return sql statemnt delimiter. |
| transInProgres | Returns true if transaction is in progress, otherwise returns false. |
Public Instance Methods
| addTableToDataSet | Overloaded. Add copy of table from original dataset to specified dataset. |
| bulkDelete | Overloaded. Bulk delete records specified with individual id. |
| clearCachedSchemasData | Schema data is cached locally. This procedure clear cache. |
| clearDataSet | Clear default dataset and close client connection. |
| close | Release all resources and clear dataAccess dataset. |
| copyTableRow | Function copy row in one table to new row in the same table and returns new ID |
| dispose | Clear dataset and close client. |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| executeScalar | Return single value. |
| executeSQL | Overloaded. Execute SQL statement without data retrieve. |
| findParents | Returns IDs for parent elements. Useful when |
| generatedTableName | Function returns generated table name for specified dataset - useful when table name needed. |
| getArrayList | Function returns first column as arrayList received by sql statement |
| getCachedSchemaData | Get schema information for specified table. |
| getDatabaseName | Get database name. |
| getDataTable | Function retrieve data from database as new table (added to dataAccess dataset). |
| 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. |
| getHashTable | Overloaded. Returns hashtable with keys as fields from first column from SQL statement and values as fields from second column defined in SQL statement. All additional columns are ignored. |
| getIdentityColumnName | Try to find column name with identity data |
| getNewDataSetWithTable | Get new instance of dataset with one datatable. |
| getRow | Get row with specified index from datatable. |
| getRows | Returns datatable rows |
| getRowValues | Overloaded. Returns values from database table row |
| getSchemaData | Returns specified Information about database table structure. |
| getSchemaTable | Get schema table for specified table. |
| getSqlSatements | Return array of sql statements. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| isDbColumnExists | Returns true if database column exists |
| isDbTableExists | Returns true when database table exists. |
| multiplyRecords | This function is primary used by SQL developers. |
| removeDatasetTable | Remove table from dataset. |
| setDataReader | Execute dataReader object included in current client for retrieving database information. |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
| transactionBegin | Begin new transaction |
| transactionCommit | Commit current transaction. |
| transactionRollback | RollBack current transaction. |
| updateDataSet | Update dataset using dataAdapter |
| updateRecord | Overloaded. Function update existing or insert new record into table. When inserts new record function made database transaction - if there is no transaction in progress. |
Protected Instance Methods
 Finalize | |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
dataAccess Class | Indoo.Data Namespace