BulkCopy Class

public class BulkCopy

Public Class BulkCopy

//DataTable implements IDataReader and can be used directly.
DataTable data = GetData();

//If you have an enumarable of objects you want to bulk copy, you can use <see href="http://www.nuget.org/packages/FastMember" />
//to create an implementation of IDataReader on the fly:

IEnumerable<Product> products = GetProducts();
IDataReader productsDataReader = FastMember.ObjectReader.Create(products);

using (var connection = new SphinxQLConnection())
{
    await connection.OpenAsync();
    using (var tx = await connection.BeginTransactionAsync())
    {
        var bulkCopy = new BulkCopy(connection, "rt");
        {
            BatchSize = 1000, //Default batch size is a very conservative 16, do some tests and adjust to what gives the best performance for your workload. You may also need to adjust max_packet_size in your searchd config.
            Progress = new Progress<int>(c => Debug.WriteLine($"{c} documents written"))
        };
        int count = await bulkLoader.CopyAsync(data);
        //or
        int count = await bulkLoader.CopyAsync(productsDataReader);
        await tx.CommitAsync();
    }
}