public async Task BulkCopy()
{
using (var cn = LocalDb.GetConnection(dbName))
{
await cn.DropAllTablesAsync();
using (var stream = GetResource("zipcode_us_geo_db.xlsx"))
{
var loader = new ExcelLoader();
var result = await loader.BulkSaveAsync(stream, cn, "dbo", "ZipCodes", 1000);
Assert.IsTrue(result == 80_237);
}
}
}
