VersaTul.Data.Bulk 1.0.7

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.