title: SQLite connection not appearing in Entity Data Model Wizard
body: <p>What i did to get where i am:
  I installed the assembly from <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="nofollow noreferrer">http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki</a> using the GAC and VS2012 options.</p>
  
  <p>I can now make a connection to an existing SQLite datebase or make a connection and create a new SQLite database file.</p>
  
  <p>This connection will appear in my server explorer and works fine.
  I can look in this database from the explorer and change tables and so on.</p>
  
  <p>However, when i try to add a new <em>ADO.NET Entity Data Model</em> this already made connection will not appear in the available data connections.
  Even if i then proceed in making a new connection, the <em>System.Data.SQLite Database File</em> option is not even in the list of options.</p>
  
  <p>I have tried installing the entity package with NuGet separately or together with the SQLite packages. I have tried not installing them or only the Entity model in combination with the previously mentioned assembly, but the option for SQLite just won't appear.</p>
  
  <p>After having googled and overflowed this for a frustrating amount of time and having found only a handfull of people that display the same problem as me but with no solution that works for me i come to you for help.</p>
  
  <p>After all my efforts, I suspect it comes down to my <em>App.config</em> file.
  Mine looks as follows:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;configuration&gt;
    &lt;configSections&gt;
      &lt;!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --&gt;
      &lt;section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt;
    &lt;/configSections&gt;
    &lt;startup&gt;
      &lt;supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /&gt;
    &lt;/startup&gt;
    &lt;entityFramework&gt;
      &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /&gt;
      &lt;providers&gt;
        &lt;provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /&gt;
        &lt;provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" /&gt;
      &lt;/providers&gt;
    &lt;/entityFramework&gt;
    &lt;system.data&gt;
      &lt;DbProviderFactories&gt;
        &lt;remove invariant="System.Data.SQLite.EF6" /&gt;
        &lt;add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" /&gt;
      &lt;/DbProviderFactories&gt;
    &lt;/system.data&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>similar problems:</p>
  
  <p><a href="https://stackoverflow.com/questions/25089346/database-first-create-entity-framework-6-1-1-model-using-system-data-sqlite-1-0">Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93</a> </p>
  
  <p><a href="http://sqlite.1065341.n5.nabble.com/Provider-not-showing-up-in-Net-Model-import-wizard-td75306.html" rel="nofollow noreferrer">http://sqlite.1065341.n5.nabble.com/Provider-not-showing-up-in-Net-Model-import-wizard-td75306.html</a></p>
  
  <p>I used vs2012 .NET 4.5, SQLite version 1.0.96.0, entity 6.1.3</p>
  
  <p>I hope someone will be able to help me.</p>