I have a Sqlite Database where I am enumerating my directory structure and inserting records into 5 different tables. Total Files + Folders count = 4000. Also there is nested loops. Can say all loops runs for 4000 times cummulative to insert the records. Earlier it was built with Sql Server where it was running absolutely fine. It was taking 3-4 seconds to insert. Later I decided to remove Sql Server and add Sqlite because of portablity, but I got stucked with the ContextSwitchDeadlock Exception. I googled and came across various forums and discussions and blogs too saying that
1. Disabling this exception type from Debug - > Exceptions -> MDA -> ContextSwitchDeadlock will resolve the issue.
2. Removing [STATThread] will also work
3. Enabling Unmanaged code debugging works too.
but none of the solution worked for me. Once again, that code was working with Sql Server but not working with Sqlite. FYI I am using Sqlite for ADO.Net 2.0 api.