Does Sql Server CE support Multithreading?


I need to know if SQL Server CE supports Multithreading (using one connection).

So if I create a SQL Server CE connection and then use that connection in two different threads to call an update/insert/delete to the connection, will SQL Server CE be "OK" with that or will it choke sometimes?

(I am getting an intermittent write error and I am not sure if it is because of multithreaded access or if it is something else.)

You must create a connection object per thread, it is not safe for multithreading -