|
Data
|
This class defines a common set of functionality that any data operation implementation can use
Inheritance Hierarchy
Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta
Syntaxpublic class DataInserter : BulkDataOperationBase
The DataInserter type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | DataInserter | Creates a new DataInserter. |
| DataInserter(Schema, Schema) | Creates a new DataInserter. |
| DataInserter(String, String) | Creates a new DataInserter. |
Properties| Name | Description | |
|---|---|---|
 | AttemptBulkInsert | Get or set to attempt use of a BULK INSERT on a destination SQL Server connection |
| AttemptTruncateTable | Set to True to attempt use of a TRUNCATE TABLE on a destination SQL Server connection if ClearDestinationTables is True and it looks like the referential integrity definition supports this. Your SQL Server connection will need the rights to perform this operation. |
| BulkInsertEncoding | This setting defines the text encoding that will be used when writing a temporary BULK INSERT file that will be needed if a SQL Server BULK INSERT is performed - make sure the encoding output matches the specified CODEPAGE value in the BulkInsertSettings property. |
| BulkInsertFilePath | This setting defines the file path that will be used when writing a temporary BULK INSERT file that will be needed if a SQL Server BULK INSERT is performed - make sure the destination SQL Server has rights to this path. |
| BulkInsertSettings | This setting defines the SQL Server BULK INSERT settings that will be used if a BULK INSERT is performed. |
| ClearDestinationTables | Set to True to clear all data from the destination database before processing data inserts. |
| DelimiterReplacement | This specifies the string that will be substituted for the field terminator or row terminator if encountered in a database value while creating a BULK INSERT file. The field terminator and row terminator values are defined in the BulkInsertSettings property specified by the FIELDTERMINATOR and ROWTERMINATOR keywords respectively. |
| ExcludedTables |
Get list of tables to be excluded during data processing
(Inherited from BulkDataOperationBase) |
| ForceBulkInsert | Get or set to force use of a BULK INSERT on a destination SQL Server connection regardless of whether or not it looks like the referential integrity definition supports this. |
| ForceTruncateTable | Set to True to force use of a TRUNCATE TABLE on a destination SQL Server connection if ClearDestinationTables is True regardless of whether or not it looks like the referential integrity definition supports this. Your SQL Server connection will need the rights to perform this operation |
| FromSchema |
Get or set Source schema
(Inherited from BulkDataOperationBase) |
| PreserveAutoIncValues | Set to True to preserve primary key value data to the destination database before processing data inserts. |
| RowReportInterval |
Get or set number of rows to process before raising progress events
(Inherited from BulkDataOperationBase) |
| Timeout |
Get or set Maximum number of seconds to wait when processing a SQL command before timing out.
(Inherited from BulkDataOperationBase) |
| ToSchema |
Get or set destination schema
(Inherited from BulkDataOperationBase) |
| UseFromSchemaReferentialIntegrity |
Get or set - use referential integrity information from source/to destination database during data processing
(Inherited from BulkDataOperationBase) |
| WorkTables |
These are the tables that were found in both source and destination to be used for data operation...
(Inherited from BulkDataOperationBase) |
Methods| Name | Description | |
|---|---|---|
| Analyze |
Analyze data schema before data processing
(Inherited from BulkDataOperationBase) |
| Close |
Close
(Overrides BulkDataOperationBaseClose) |
 | Dispose |
Dispose
(Inherited from BulkDataOperationBase) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| Execute |
Execute this DataInserter (Overrides BulkDataOperationBaseExecute) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| OnOverallProgress |
Raise an event to show overall progress of data processing
(Inherited from BulkDataOperationBase) |
| OnRowProgress |
Raise an event while change row in data processing
(Inherited from BulkDataOperationBase) |
| OnSQLFailure |
Raise an event if SQL statement fail
(Inherited from BulkDataOperationBase) |
| OnTableProgress |
Raise an event if table change in data processing
(Inherited from BulkDataOperationBase) |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
Events| Name | Description | |
|---|---|---|
 | BulkInsertCompleted | Bulk-insert completed event. |
| BulkInsertException | Bulk-insert exception event. |
| BulkInsertExecuting | Bulk-insert executing event. |
| Disposed | Disposed event. |
| OverallProgress |
Get the information of overall progress of Migration utility
(Inherited from BulkDataOperationBase) |
| RowProgress |
Get the information of Row progress of table
(Inherited from BulkDataOperationBase) |
| SQLFailure |
Get the information of exception while processing SQL statement
(Inherited from BulkDataOperationBase) |
| TableCleared | Table cleared event. |
| TableProgress |
Get the status information of table progress
(Inherited from BulkDataOperationBase) |
Fields| Name | Description | |
|---|---|---|
 | m_fromSchema |
From schema.
(Inherited from BulkDataOperationBase) |
| m_overallProgress |
Implementer can use this variable to track overall progress
(Inherited from BulkDataOperationBase) |
| m_overallTotal |
This is initialized to the overall total number of records to be processed
(Inherited from BulkDataOperationBase) |
| m_tableCollection |
Tables value
(Inherited from BulkDataOperationBase) |
| m_timeout |
Timeout value for SQL operation
(Inherited from BulkDataOperationBase) |
| m_toSchema |
To schema.
(Inherited from BulkDataOperationBase) |
| m_useFromSchemaRI |
Flag to check referential integrity
(Inherited from BulkDataOperationBase) |
Extension Methods| Name | Description | |
|---|---|---|
 | GetEnumValueOrDefault |
Gets the enumeration constant for value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions) |
| GetEnumValueOrDefaultT |
Gets the enumeration constant for this value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions) |
See Also