Bulk Insert does not respect identity insert option #393
Description
The best way to explain this is with code. The following works I can insert a value into an identity column
using (var scope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromSeconds(5 * 60)))
{
foreach(var item in results)
{
Simple.Data.Database.
OpenConnection(destionationDBConnectionString).
WithOptions(new Simple.Data.Ado.AdoOptions(commandTimeout: (5 * 60), identityInsert: true))
[this.destinationTableName].Insert(item);
}
scope.Complete();
}
This does not. The table puts in the identity value:
using (var scope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromSeconds(5 * 60)))
Simple.Data.Database.
OpenConnection(destionationDBConnectionString).
WithOptions(new Simple.Data.Ado.AdoOptions(commandTimeout: (5 * 60),identityInsert: true))
[this.destinationTableName].Insert(results);
scope.Complete();
}
I will try and examine the code and see if it can be fixed easily.