/// <summary>
/// Write to server async
/// </summary>
/// <param name="table"></param>
/// <param name="cancellationToken"></param>
/// <returns></returns>
public async Task WriteToServerAsync(DataTable table, CancellationToken cancellationToken = default)
{
var bulkLoader = MySqlBulkCopyHelper.GetBulkLoader(_connection, table, DestinationTableName, BulkCopyTimeout, SecureFilePriv);
UpdateCurrentFilePath(bulkLoader.FileName);
UpdateColumnInfo(bulkLoader, table);
await bulkLoader.LoadAsync(cancellationToken);
}
/// <summary>
/// Write to server
/// </summary>
/// <param name="table"></param>
public void WriteToServer(DataTable table)
{
var bulkLoader = MySqlBulkCopyHelper.GetBulkLoader(_connection, table, DestinationTableName, BulkCopyTimeout, SecureFilePriv);
UpdateCurrentFilePath(bulkLoader.FileName);
UpdateColumnInfo(bulkLoader, table);
bulkLoader.Load();
}