| | 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
|
Fields