title: Unable to find the requested .Net Framework Data Provider - SQLite
body: <p>I thought that sqlite was simple but it is giving me a hard time. I just want to create an application where I can connect to a sqlite database using the ado.net entity data classes.</p>
  
  <p>I am having this problem when testing the application on a virtual computer running windows xp. the application works fine on my current computer and also on my laptop when I deploy them. </p>
  
  <p>Here is what happens on the virtual computer :</p>
  
  <ul>
  <li>The application is able to launch.</li>
  <li>The application is able to interact with the database using System.Data.SQLite</li>
  <li><strong>The application is not able to connect to the database using The ADO.NET Entity data models</strong></li>
  </ul>
  
  <p>when I try to connect I get the following exception:</p>
  
  <p><img src="https://i.stack.imgur.com/evOLa.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/ynSGJ.png" alt="enter image description here"></p>
  
  <p><strong>I know there are a lot of post that talk about this and most of them say that you need to download the <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="noreferrer">.NET provider for Sqlite.</a></strong></p>
  
  <p>I have already installed the sqlite-netFx40-setup-bundle-x86-2010-1.0.79.0.exe  and I get the same problem. What should I do?</p>
  
  <hr>
  
  <h2>Edit</h2>
  
  <p>I managed to establish a connection by adding:</p>
  
  <pre><code>&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" /&gt;
  &lt;/DbProviderFactories&gt;
  </code></pre>
  
  <p></p>
  
  <p>to my app.config file.</p>
  
  <p>The problem is that now I cannot select data nor insert records to the database. The exception that I get when I try to insert a new record now is:</p>
  
  <p>A null was returned after calling the 'GetService' method on a store provider instance of type 'System.Data.SQLite.SQLiteFactory'. The store provider might not be functioning correctly.</p>
  
  <p><img src="https://i.stack.imgur.com/NTeLb.png" alt="enter image description here"></p>