Task |
Helper class to perform database operations (load, create and insert tables, execute SQL statements), used from Razor scripts of report tasks
Inheritance HierarchyNamespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.0.1.0+a44cd3a7f03c2bf3cdbd971a878c679e40bed08a
SyntaxC#
public class TaskDatabaseHelper
The TaskDatabaseHelper type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | TaskDatabaseHelper | Initializes a new instance of the TaskDatabaseHelper class |
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) |
Fields| Name | Description | |
|---|---|---|
 | ColumnCharLength | 0 = means auto size |
| ColumnCharType | Database column type used for character columns (if empty, the default of the current database type is used) |
| ColumnDateTimeType | Database column type used for date time columns (if empty, the default of the current database type is used) |
| ColumnIntegerType | Database column type used for integer columns (if empty, the default of the current database type is used) |
| ColumnNumericType | Database column type used for numeric columns (if empty, the default of the current database type is used) |
| DatabaseType | Current database type used for the default configuration (set by SetDatabaseDefaultConfiguration) |
| DebugLog | Log of the SQL commands executed when DebugMode is true |
| DebugMode | If true, the SQL commands executed are traced in the DebugLog |
| DefaultEncoding | Default encoding used to load CSV files |
| ExecuteTimeout | Command timeout in seconds used to execute statements (0 means no timeout) |
| InsertBurstSize | Number of rows inserted per INSERT batch |
| InsertEndCommand | Statement added after the INSERT commands (if empty, the default of the current database type is used, e.g. 'end;' for Oracle) |
| InsertStartCommand | Statement added before the INSERT commands (if empty, the default of the current database type is used, e.g. 'begin' for Oracle) |
| InsertTableHints | Optional table hints for insert |
| LoadBurstSize | 0 = Load all records in one |
| LoadSortColumn | Sort column used if LoadBurstSize is specified |
| MaxDecimalNumber | If set, limit the number of decimals for numeric values |
| MyDetectAndConvertTypes | If set, custom delegate used instead of the default implementation to detect column types and convert the values of a table |
| MyGetTableColumnName | If set, custom delegate used instead of the default implementation to get a database column name |
| MyGetTableColumnNames | If set, custom delegate used instead of the default implementation to build the list of column names |
| MyGetTableColumnType | If set, custom delegate used instead of the default implementation to get a database column type |
| MyGetTableColumnValue | If set, custom delegate used instead of the default implementation to get the SQL value of a column for an INSERT statement |
| MyGetTableColumnValues | If set, custom delegate used instead of the default implementation to build the list of values of a row for an INSERT statement |
| MyGetTableCreateCommand | If set, custom delegate used instead of the default implementation to build the CREATE TABLE command |
| MyLoadDataTable | If set, custom delegate used instead of the default implementation to load a DataTable from a connection |
| MyLoadDataTableFromCSV | If set, custom delegate used instead of the default implementation to load a DataTable from a CSV file |
| MyLoadDataTableFromExcel | If set, custom delegate used instead of the default implementation to load a DataTable from an Excel file |
| NoRowsCharLength | Char length taken if the table loaded as no row |
| RemoveCrLf | If true, carriage returns and line feeds are replaced by spaces in text values before insert |
| SelectTimeout | Command timeout in seconds used for SELECT statements (0 means no timeout) |
| TableLoadDetectAndConvertTypes | If true, column types can be detected and values converted during a table load to database (For CSV and Excel load) |
| TrimText | If true, text values are trimmed before insert |
| UseDbDataAdapter | If true, a DbDataAdapter is used to fill the DataTable instead of a DataReader |
| UseMultiRowsInsert | /If true, insert command is built with multi rows |
See Also