Exclusive but shared for reading using SqlCeConnection
Connection string
This .NET Compact Framework Data Provider for SQL Server Mobile connection string can be used for connections to SQL Server Compact.
Use this one to allow other processes to read, but not modify, the database while you have it open.
Data Source=MyData.sdf;File Mode=Shared Read;Persist Security Info=False;