title: How to make Entity Framework CTP5 work with SQLite?
body: <p>I am having a very hard time in using the SQLite db with EF CTP5. I was just trying to execute this <a href="http://blogs.msdn.com/b/adonet/archive/2010/12/06/ef-feature-ctp5-code-first-walkthrough.aspx?wa=wsignin1.0" rel="nofollow noreferrer">MSDN example</a> with SQLite. But at the line </p>
  
  <pre><code>var food = db.Categories.Find("FOOD");
  </code></pre>
  
  <p>I am getting a runtime exception:</p>
  
  <blockquote>
    <p>System.Data.SQLite.SQLiteException (0x80004005): SQLite errorno such table: Categories</p>
  </blockquote>
  
  <p>Note: The app.config file has to be modified and is as follows:</p>
  
  <p><strong>App.config</strong></p>
  
  <pre><code>&lt;configuration&gt;
    &lt;startup useLegacyV2RuntimeActivationPolicy="true"&gt;
      &lt;supportedRuntime version="v4.0" /&gt;
    &lt;/startup&gt;
    &lt;runtime&gt;
      &lt;generatePublisherEvidence enabled="false" /&gt;
    &lt;/runtime&gt;
    &lt;system.data&gt;
      &lt;DbProviderFactories&gt;
        &lt;remove invariant="System.Data.SQLite"/&gt;
        &lt;add name="SQLite Data Provider" invariant="System.Data.SQLite"
             description=".Net Framework Data Provider for SQLite"
             type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /&gt;
      &lt;/DbProviderFactories&gt;
    &lt;/system.data&gt;
    &lt;connectionStrings&gt;
      &lt;add name="ProductContext" connectionString="Data Source=D:\CodeFirst.db;Version=3;New=True;" providerName="System.Data.SQLite" /&gt;
    &lt;/connectionStrings&gt;
  &lt;/configuration&gt;
  </code></pre>