public void ExecuteBulkCopyAsync_ShouldCreateNewRows_WhenUsingEvents()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(map => map.UseAutoMap())
.Events(events => events.NotifyAfter(10).OnRowsCopied((sender, e) =>
{
var sqlRowsCopiedEventArgs = (SqlRowsCopiedEventArgs)e;
WriteLine($"Total rows copied: {sqlRowsCopiedEventArgs.RowsCopied}");
}))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopy_ShouldCreateNewRows_WhenUsingPartialMapper()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Alter the DataTable to simulate a source where the SampleVarChar field is named something different
dataTable.Columns["SampleVarChar"].ColumnName = "SampleString";
// Now specify the mapping
var columnMapping = new ColumnMapping
{
ColumnMaps = new List <ColumnMap>
{
new ColumnMap("SampleString", "SampleVarChar")
}
};
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(opt => opt.UsePartialMap(columnMapping))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopy_ShouldCreateNewRows_WhenUsingMap()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Alter the DataTable to simulate a source where all column names are different than the destination
dataTable.Columns["SampleInt"].ColumnName = "Column1";
dataTable.Columns["SampleSmallInt"].ColumnName = "Column2";
dataTable.Columns["SampleTinyInt"].ColumnName = "Column3";
dataTable.Columns["SampleBit"].ColumnName = "Column4";
dataTable.Columns["SampleDecimal"].ColumnName = "Column5";
dataTable.Columns["SampleFloat"].ColumnName = "Column6";
dataTable.Columns["SampleVarChar"].ColumnName = "Column7";
// Now specify the mapping
var columnMapping = new ColumnMapping
{
ColumnMaps = new List <ColumnMap>
{
new ColumnMap("Column1", "SampleInt"),
new ColumnMap("Column2", "SampleSmallInt"),
new ColumnMap("Column3", "SampleTinyInt"),
new ColumnMap("Column4", "SampleBit"),
new ColumnMap("Column5", "SampleDecimal"),
new ColumnMap("Column6", "SampleFloat"),
new ColumnMap("Column7", "SampleVarChar"),
}
};
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(opt => opt.UseMap(columnMapping))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopy_ShouldCreateNewRows_WhenUsingAutoMapper()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(opt => opt.UseAutoMap())
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopyAsync_ShouldCreateNewRows_WhenUsingOrderHints()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(map => map.UseAutoMap())
.OrderHints(hints => hints.OrderBy("SampleInt").OrderByDescending("SampleSmallInt"))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopyAsync_ShouldCreateNewRows_WhenUsingOptions()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(map => map.UseAutoMap())
.Options(options => options.KeepNulls().CheckConstraints().TableLock(false))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public void ExecuteBulkCopyAsync_ShouldCreateNewRows_WhenUsingAllApis()
{
// Arrange
DataTable dataTable = GetDataToInsert();
// Alter the DataTable to simulate a source where the SampleVarChar field is named something different
dataTable.Columns["SampleVarChar"].ColumnName = "SampleString";
// Act
BulkCopyResult result = SUT.BuildCommand()
.ForBulkCopy <SampleEntity>()
.From(dataTable, DataRowState.Added)
.Into("[dbo].[SampleTable]")
.Options(options => options.KeepNulls().CheckConstraints().TableLock(false).OpenConnectionWithoutRetry())
.OrderHints(hints => hints.OrderBy("SampleInt").OrderByDescending("SampleSmallInt"))
.BatchSize(100)
.Timeout(TimeSpan.FromSeconds(30))
.Mapping(mapping => mapping.UsePartialMap(sample =>
{
sample.Property(s => s.SampleVarChar).MapFrom("SampleString");
}))
.Events(events => events.NotifyAfter(10).OnRowsCopied((sender, e) =>
{
var sqlRowsCopiedEventArgs = (SqlRowsCopiedEventArgs)e;
WriteLine($"Total rows copied: {sqlRowsCopiedEventArgs.RowsCopied}");
}))
.OrderHints(hints => hints.Build(entity =>
{
entity.Property(e => e.SampleInt).OrderByDescending();
}))
.Execute();
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(RowCount);
}
public async Task ExecuteBulkCopyAsync_ShouldCreateNewRows_WhenUsingStronglyTypedMap()
{
// Arrange
int expectedCount = ExecuteScalar <int>("SELECT COUNT(1) FROM [dbo].[SampleTable]") + RowCount;
DataTable dataTable = GetDataToInsert();
// Alter the DataTable to simulate a source where all column names are different than the destination
dataTable.Columns["SampleInt"].ColumnName = "Column1";
dataTable.Columns["SampleSmallInt"].ColumnName = "Column2";
dataTable.Columns["SampleTinyInt"].ColumnName = "Column3";
dataTable.Columns["SampleBit"].ColumnName = "Column4";
dataTable.Columns["SampleDecimal"].ColumnName = "Column5";
dataTable.Columns["SampleFloat"].ColumnName = "Column6";
dataTable.Columns["SampleVarChar"].ColumnName = "Column7";
// Act
BulkCopyResult result = await SUT.BuildCommand()
.ForBulkCopy <SampleEntity>()
.From(dataTable)
.Into("[dbo].[SampleTable]")
.Mapping(mapping => mapping.UseMap(sample =>
{
sample.Property(s => s.SampleInt).MapFrom("Column1");
sample.Property(s => s.SampleSmallInt).MapFrom("Column2");
sample.Property(s => s.SampleTinyInt).MapFrom("Column3");
sample.Property(s => s.SampleBit).MapFrom("Column4");
sample.Property(s => s.SampleDecimal).MapFrom("Column5");
sample.Property(s => s.SampleFloat).MapFrom("Column6");
sample.Property(s => s.SampleVarChar).MapFrom("Column7");
}))
.ExecuteAsync(new CancellationToken());
// Assert
result.ShouldNotBeNull();
result.RowCountCopied.ShouldBe(RowCount);
// Print
WriteLine(expectedCount);
}