sql-server-ce - 多用户场景中的 SQL Server CE - 这真的非常愚蠢吗？

Question

我正在尝试使用 SQL Server Compact Edition 3.5 作为销售应用程序的数据库后端。将安装 3-4 个 Windows 窗体应用程序，所有这些应用程序(通过 LINQ2SQL)都可以读取和写入位于网络共享上的一个 .sdf 文件。

我的(相当少的)测试表明这可能是可行的。 Documentation声明 SQL Server CE 最多支持 256 个连接。 Does SQL Server CE even lock its rows?还有其他我应该担心的并发问题吗？

底线是，是否有人成功地将 SQL Server CE 用于连接到同一数据库的多个应用程序？

我应该避免将来的麻烦并使用 SQL Server Express 吗？

Answer 1

MS 推荐(来自 Darian Miller 的 comparison guide):

When you require data service functionality, such as the ability to support multiple, remote users, you should start with SQL Server Express Edition and work up the data service family tree.

运行时支持在同一台机器上并发，不确定多台机器访问文件。如果文件存储在网络共享上，则可能不适合 ce 的最佳性能配置文件。我会说和 EE 一起去，用一个简单的 msi 安装很容易。

SSCE并发:

SSCE allows multiple connections to the same database (.sdf file) from the same application or even multiple applications on the same computer. This gives you more freedom to structure your application as needed, such as allowing the user to continue to interact with data while performing synchronization with a back-end database, or to have multiple applications on the same machine share an SSCE data store. Transactional concurrency locks are made by the database engine to prevent concurrent connections from accessing the same records at the same time. The technical limit on concurrent connections for a single database is 256, but 70-80 is a better practical limit from a performance perspective.

http://technet.microsoft.com/en-us/library/bb380177%28SQL.90%29.aspx