Does Sql Server CE support Multithreading?

advertisements

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 - http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection(v=VS.100).aspx