Task |
The TaskDatabaseHelper type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AreRowsIdentical | Returns true if two rows have identical values |
| AreTablesIdentical | Returns true if two tables have identical rows and values |
| CreateTable | Drop and create a table in the database from a DataTable definition |
| DetectAndConvertTypes | Detect the column types (integer, double, date time) of a source table containing string columns and return a new table with converted values |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| ExecuteCommand | Execute a DbCommand (the command is traced in the DebugLog if DebugMode is true) |
| ExecuteNonQuery(MetaConnection, String, String) | Execute a SQL statement on a MetaConnection. Several statements may be executed using a commands separator. |
| ExecuteNonQuery(ConnectionType, String, String, String, DbConnection) | Execute a SQL statement on a connection. Several statements may be executed using a commands separator. |
| ExecuteScalar(MetaConnection, String) | Execute a SQL statement on a MetaConnection and return the first column of the first row of the result |
| ExecuteScalar(ConnectionType, String, String, DbConnection) | Execute a SQL statement on a connection and return the first column of the first row of the result |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetDatabaseName | Returns a valid database object name from a given name: invalid characters are replaced and the name is quoted according to the current database type |
| GetDbCommand | Returns a DbCommand created from a DbConnection |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetInsertCommand | Returns the final INSERT command with the insert start and end commands added |
| GetTableColumnName | Returns the database column name of a column (uses MyGetTableColumnName if defined) |
| GetTableColumnNames | Returns the comma-separated list of column names of a table (uses MyGetTableColumnNames if defined) |
| GetTableColumnType | Returns the database column type of a column (uses MyGetTableColumnType if defined) |
| GetTableColumnValue | Returns the SQL value of a column of a row for an INSERT statement (uses MyGetTableColumnValue if defined) |
| GetTableColumnValues | Returns the comma-separated list of values of a row for an INSERT statement (uses MyGetTableColumnValues if defined) |
| GetTableCreateCommand | Returns the CREATE TABLE command for a DataTable (uses MyGetTableCreateCommand if defined) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| InsertTable | Insert the rows of a DataTable in the database table within a transaction (rows may be deleted first) |
| IsNumeric | Returns true if the column has a numeric type |
| IsRowEmpty | Returns true if a row of an Excel worksheet is empty |
| LoadDataTable(MetaConnection, String) | Load a DataTable from a MetaConnection using a SQL SELECT statement |
| LoadDataTable(ConnectionType, String, String, DbConnection) | Load a DataTable from a connection using a SQL SELECT statement (an open connection may be provided) |
| LoadDataTableFromCSV | Load a DataTable from a CSV file |
| LoadDataTableFromCSVVBParser | Load a DataTable from a CSV file using the Microsoft Visual Basic Parser |
| LoadDataTableFromExcel | Load a DataTable from an Excel tab. A start row, and/or column can be specified. An end row and/or column can be specified. |
| LoadStringList | Load a list of strings from a MetaConnection using a SQL SELECT statement (first column of the result) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| OdbcLoadDataTable | Load a DataTable from an ODBC connection using a SQL SELECT statement |
| RawInsertTable | Insert rows given as arrays of SQL literal values in a database table within a transaction (rows may be deleted first) |
| RootGetTableColumnName | Default implementation to get the database column name of a column |
| RootGetTableColumnNames | Default implementation to build the comma-separated list of column names of a table |
| RootGetTableColumnType | Default implementation to get the database column type of a column |
| RootGetTableColumnValue | Default implementation to get the SQL value of a column of a row for an INSERT statement |
| RootGetTableColumnValues | Default implementation to build the comma-separated list of values of a row for an INSERT statement |
| RootGetTableCreateCommand | Default implementation to build the CREATE TABLE command for a DataTable |
| SetDatabaseDefaultConfiguration | Set the default configuration values (column types, insert commands) for a given database type |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
See Also