Batch updates in EF

[peledkfir]

Hi,
I wish to know if there is a possibility to config only a specific context to use batch updates instead of configure it globally?
Another question, is there any way to use transactions with batch updates?

Thanks, Kfir

[Shalex]

I wish to know if there is a possibility to config only a specific context to use batch updates instead of configure it globally?

Please use the following code to turn on/off batch updates:

Code: Select all

OracleEntityProviderConfig config = OracleEntityProviderConfig.Instance;  
config.DmlOptions.BatchUpdates.Enabled = true;
...
config.DmlOptions.BatchUpdates.Enabled = false;

Another question, is there any way to use transactions with batch updates?

Each SaveChanges() is executed in its own local transaction. TransactionScope cannot be used with batch updates.

For more information, refer to http://www.devart.com/blogs/dotconnect/ ... html#Batch.

[peledkfir]

1. In multi-threaded application it seems that your solution for enabling batch will effect all thread in the application - which is not good enough for my case..
2. I already read that post. My question was if there an other way to work with transacation that is not TransactionScope with batches like beginTransaction

10x for your response

[Shalex]

1. Yes, this will effect all threads in the application. There is no other way.
2. Why do you need to wrap SaveChanges() in local transaction if it is executed in its own transaction?

[peledkfir]

2. Because I need distributed transactions

[Shalex]

2. TransactionScope (distributed transactions) cannot be used with batch updates.