Josh
Josh

Reputation: 204

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

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

Answers (1)

Mitch Wheat
Mitch Wheat

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

Related Questions