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
Post a Comment