I am trying to get some information after successful BulkMerge operation. I want to know, how many rows are updated and how many are inserted. I was trying with Transaction but had no luck with that.
My code :
using (var transactionScope = new TransactionScope())
{
Connection.BulkMerge(compUsers);
transactionScope.Complete();
var x = transactionScope;
}
compUsers is list with data that will be inserted/updated. But I have no idea how to get some relevant information about this transaction. Thanks in advance.
Unfortunately this isn't possible.
As explained by JonathanMagnan on this link. https://github.com/zzzprojects/Dapper-Plus/issues/34