title: Database file .sdf does not update after closing application
body: <p>I am creating a Desktop application using Microsoft Visual Studio .NET 2008. I am using a .sdf file as my database. My problem is that when I am making changes to my records (add new, deleted, updated) then the changes reflects only while my application is running. When I restart the application then I am not getting my changes.</p>
  
  <p>I am using the default connection string</p>
  
  <pre><code>string conString = Properties.Settings.Default.DataConnectionString;
  SqlCeConnection con = new SqlCeConnection(conString);
  con.Open();
  </code></pre>
  
  <p>The value given by Visual Studio for this database is</p>
  
  <blockquote>
    <p>Data Source=|DataDirectory|\Data.sdf</p>
  </blockquote>
  
  <p>I don't know what mistake I am doing, but all the queries are executing. </p>