title: SQL Server CE table not found error
body: <p>I am trying to use SQL Server CE on Windows Phone Mango. Here is my <code>DataContext</code>:</p>
  
  <pre><code>public class FooDataContext : DataContext
  {
      private static readonly string DB_CONNECTION_STRING = "Data Source=isostore:/foo.sdf";
  
      // Pass the connection string to the base class.
      public FooDataContext() : base(DB_CONNECTION_STRING)
      { }
  
      // can this be a property?
      public Table&lt;Foo&gt; Items;
  
      public void ClearDatabase()
      {
          if (DatabaseExists())
          {
              DeleteDatabase();
          }
      }
  
      public void EnsureDatabaseExists()
      {
          if (!DatabaseExists())
          {
              CreateDatabase();
              SubmitChanges();
          }
      }
  }
  </code></pre>
  
  <p>In the constructor of the main page, I call <code>EnsureDatabaseExists()</code>. If I've changed the schema, I also include a call to <code>ClearDatabase()</code>:</p>
  
  <pre><code>//fooData.ClearDatabase();
  fooData.EnsureDatabaseExists();
  </code></pre>
  
  <p><code>Foo</code>'s columns are <code>int</code>, <code>double</code>, and <code>DateTime</code>. When I run the app without the <code>ClearDatabase()</code> call, I get the following error as soon as I try to access <code>fooContext.Items</code>:</p>
  
  <blockquote>
    <p>The specified table does not exist. [ Foo ]</p>
  </blockquote>
  
  <p>What is going on here? If I freshly install the app, everything works fine.</p>