c# - How do I disable LINQ to Sql transactions? -


I want to add additional to a database, in this case a large amount of information, no transactions on my SQL SQL model from SQL is . Does anyone know how to turn off SQL transactions from the LINQ on Datacontext or how to submit the operation of the changes?

As far as I can tell, to simplify the recovery mode from the database There is no way to disable the transaction without putting.

Be careful though, because you can recover a database with only a simple recovery mode for the latest backup and will not be able to apply the transaction logs after the transaction that occurred after that backup.

If you can configure a batch size (I know that with NHibernate, LINQ is not positive about SQL) we can do something like 100 or more, which can be used as a database Can also reduce round trips which will also increase the combined performance. .


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

jquery - SimpleModal Confirm fails to submit form -

php - Multiple Select with Explode: only returns the word "Array" -