How can I get the number of records that were inserted?
Is there an easier way, with L2S, than count before and count after and taking the difference?
+2
A:
Can you try use this functionality ?
_db.GetChangeSet().Inserts.Count();
Where _db - your datacontext and it need to do before sumbit your changes ?
Maksim Kondratyuk
2009-04-28 12:46:51
A:
The db.SubmitChanges does not give you the actual records that were affected by the inserts, deletes and updates to the database. Looking at db.GetChangeSet.Count() does give you the truth. It is only when an error occurs during the SubmitChanges call that the numbers in the GetChangeSet.Count() will differ from the actual situation in the db.
craziac
2009-04-28 12:53:00
In the case of an error during submit changes, everything is rolled back, correct?
Ronnie Overby
2009-04-28 13:35:35
Yes, according to http://stackoverflow.com/questions/542525/transactionscope-vs-transaction-in-linq2sql
Rafe Lavelle
2009-09-30 13:05:19