VersaTul Data Bulk

VersaTul Data Bulk is a project that provides the ability to setup bulk coping functionality for copying data to and from different data sources.

Features

• Common interfaces and implementations for database or data source specific copiers
• Customizable batch size and streaming options
• Support for flat file and IDataReader sources

Usage

To use VersaTul Data Bulk, you need to implement the IBulkCopy interface and provide the necessary parameters for the source and destination data sources. You also need to create a collection of CopyDetail objects that represent the details of the bulk copy, such as the source column, destination column, source ordinal, and destination ordinal. Then, you can call the DoCopy method to perform the bulk copy operation.

Here is a simple example using a flat file as the source:

// Create a flat file bulk copy object FlatFileBulkCopy flatFileBulkCopy = new FlatFileBulkCopy(); // Create a collection of copy details List<CopyDetail> copyDetails = new List<CopyDetail>(); // Add a copy detail for each column copyDetails.Add(new CopyDetail("Name", "Name", 0, 0)); copyDetails.Add(new CopyDetail("Age", "Age", 1, 1)); copyDetails.Add(new CopyDetail("Gender", "Gender", 2, 2)); // Set the batch size and enable streaming flatFileBulkCopy.BatchSize = 1000; flatFileBulkCopy.EnableStreaming = true; // Perform the bulk copy flatFileBulkCopy.DoCopy(copyDetails);

Here is a simple example using an IDataReader as the source:

// Create a data reader bulk copy object DataReaderBulkCopy dataReaderBulkCopy = new DataReaderBulkCopy(); // Create a collection of copy details List<CopyDetail> copyDetails = new List<CopyDetail>(); // Add a copy detail for each column copyDetails.Add(new CopyDetail("Name", "Name", 0, 0)); copyDetails.Add(new CopyDetail("Age", "Age", 1, 1)); copyDetails.Add(new CopyDetail("Gender", "Gender", 2, 2)); // Set the batch size and enable streaming dataReaderBulkCopy.BatchSize = 1000; dataReaderBulkCopy.EnableStreaming = true; // Create a data reader from a data source IDataReader dataReader = ...; // Perform the bulk copy dataReaderBulkCopy.DoCopy(dataReader, copyDetails);

License

This project is licensed under the MIT License - see the LICENSE file for details.