Click or drag to resize

TaskDatabaseHelper Class

Inheritance Hierarchy
SystemObject
  Seal.HelpersTaskDatabaseHelper

Namespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 8.3.0.0+c4d725cbae26375217e6c77c92a07fffaea6377d
Syntax
C#
public class TaskDatabaseHelper

The TaskDatabaseHelper type exposes the following members.

Constructors
 NameDescription
Public methodTaskDatabaseHelperInitializes a new instance of the TaskDatabaseHelper class
Top
Methods
 NameDescription
Public methodAreRowsIdentical 
Public methodAreTablesIdentical 
Public methodCreateTable 
Public methodDetectAndConvertTypes 
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Public methodExecuteCommand 
Public methodExecuteNonQuery(MetaConnection, String, String) 
Public methodExecuteNonQuery(ConnectionType, String, String, String, DbConnection) 
Public methodExecuteScalar(MetaConnection, String) 
Public methodExecuteScalar(ConnectionType, String, String, DbConnection) 
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
Public methodGetDatabaseName 
Public methodGetDbCommand 
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetInsertCommand 
Public methodGetTableColumnName 
Public methodGetTableColumnNames 
Public methodGetTableColumnType 
Public methodGetTableColumnValue 
Public methodGetTableColumnValues 
Public methodGetTableCreateCommand 
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodInsertTable 
Public methodIsNumeric 
Public methodIsRowEmpty 
Public methodLoadDataTable(MetaConnection, String) 
Public methodLoadDataTable(ConnectionType, String, String, DbConnection) 
Public methodLoadDataTableFromCSV 
Public methodLoadDataTableFromCSVVBParser 
Public methodLoadDataTableFromExcel 
Public methodLoadStringList 
Protected methodMemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Public methodOdbcLoadDataTable 
Public methodRawInsertTable 
Public methodRootGetTableColumnName 
Public methodRootGetTableColumnNames 
Public methodRootGetTableColumnType 
Public methodRootGetTableColumnValue 
Public methodRootGetTableColumnValues 
Public methodRootGetTableCreateCommand 
Public methodSetDatabaseDefaultConfiguration 
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Top
Fields
 NameDescription
Public fieldColumnCharLength 0 = means auto size
Public fieldColumnCharType 
Public fieldColumnDateTimeType 
Public fieldColumnIntegerType 
Public fieldColumnNumericType 
Public fieldDatabaseType 
Public fieldDebugLog 
Public fieldDebugMode 
Public fieldDefaultEncoding 
Public fieldExecuteTimeout 
Public fieldInsertBurstSize 
Public fieldInsertEndCommand 
Public fieldInsertStartCommand 
Public fieldInsertTableHints Optional table hints for insert
Public fieldLoadBurstSize 0 = Load all records in one
Public fieldLoadSortColumn Sort column used if LoadBurstSize is specified
Public fieldMaxDecimalNumber If set, limit the number of decimals for numeric values
Public fieldMyDetectAndConvertTypes 
Public fieldMyGetTableColumnName 
Public fieldMyGetTableColumnNames 
Public fieldMyGetTableColumnType 
Public fieldMyGetTableColumnValue 
Public fieldMyGetTableColumnValues 
Public fieldMyGetTableCreateCommand 
Public fieldMyLoadDataTable 
Public fieldMyLoadDataTableFromCSV 
Public fieldMyLoadDataTableFromExcel 
Public fieldNoRowsCharLength Char length taken if the table loaded as no row
Public fieldRemoveCrLf 
Public fieldSelectTimeout 
Public fieldTableLoadDetectAndConvertTypes If true, column types can be detected and values converted during a table load to database (For CSV and Excel load)
Public fieldTrimText 
Public fieldUseDbDataAdapter 
Public fieldUseMultiRowsInsert /If true, insert command is built with multi rows
Top
See Also