Concurrent Access From Multiple Processes to Single Sql Server Compact Database File

Question

My understanding is that Sql Server compact is intended to be a data store for single application that runs in-process. It is OK for two different processes to connect to and access data from the same .sdf file?

Answer 1

Yes.

SQL Server Compact supports multiple connections up to the 256 connection limit. Opening connections on different processes is also supported.

Ref.