Reputation: 204
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?
Upvotes: 5
Views: 2018
Reputation: 300827
Yes.
SQL Server Compact supports multiple connections up to the 256 connection limit. Opening connections on different processes is also supported.
Ref.
Upvotes: 7