Devart Forums

Hi,

Yesterday I was going through the Devart's website and I came to know that we can do batching using the "dotConnect for SQLite". So, I created an application (creating using Entity Framework Code First & dotConnect for SQLite) to test what kind of performance gain I get out of the batching.

So, I figured out that there was no performance gain I got using the batching. I just want that you guys could take a look at the code and let me know if, I am doing anything wrong.

You can download the sample application from https://onedrive.live.com/redir?resid=2 ... ile%2c.zip.

Thank you

Sincerely,
Pankaj Sachdeva

Thank you for the test project.

SQLite is a local embedded database; that is why, the use of Batch Updates for SQLite does not always guarantee an increase in performance. In some cases, it might actually result in a performance decrease.