title: SQL Server CE in a multi user scenario - is this really, really stupid?
body: <p>I am trying to use SQL Server Compact Edition 3.5 as a database backend for a sales application. There would be 3-4 installations of a Windows Forms application which would all (via LINQ2SQL) read from and write to one .sdf file located on a network share.</p>
  
  <p>My (pretty inextensive) testing has shown that this could be viable. <a href="http://msdn.microsoft.com/en-us/library/cc645984.aspx" rel="nofollow noreferrer">Documentation</a> states that SQL Server CE supports up to 256 connections. <a href="https://stackoverflow.com/questions/1342358/sql-server-ce-addin-read-and-write-collision-avoidance">Does SQL Server CE even lock its rows?</a> Are there other concurrency issues that I should worry about? </p>
  
  <p>Bottom line is, has anyone used SQL Server CE successfully with multiple applications connecting to same database?</p>
  
  <p>Should I spare myself future headaches and go with SQL Server Express?</p>