public void SqlBulkInsertSimpleClass()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
BddStringExtensions._("Create the table", () =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
BddStringExtensions._("Insert into the table", () =>
{
var listOfSimpleClass = Enumerable.Range(0, 1000).Select(i => SimpleClass.GetSample()).ToList();
connectionProvider.BulkInsert(listOfSimpleClass, "SimpleClass");
});
}
}
