title: Asp.Net app using SQL Server CE 4.0 causes sharing exception with multiple clients
body: <p>I have an ASP.Net 4.0 website which uses SQL Server CE and EF code-first for its data store.  When 2 or more users are on the site I intermittently get the following exception about every 5th or 6th time.</p>
  
  <blockquote>
    <p>There is a file sharing violation. A different process might be using
    the file. [D:\directory...\file.sdf].</p>
  </blockquote>
  
  <p>Throughout the code I create, use, and promptly dispose of the <code>DbContext</code> each time one is needed. Even though it is the default, I have added <code>File Mode = Read Write</code> to the connection string.</p>
  
  <p>Any ideas what I might be doing wrong.</p>