SQLite connection not appearing in Entity Data Model Wizard

c# database entity-framework sqlite

Question

How I got here: I used the GAC and VS2012 settings to install the assembly from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki.

Now, I have the option to connect to an already-existing SQLite database or connect to build a new SQLite database file.

My server explorer will display this connection, and it is functional. I can use the explorer to browse this database and change tables, among other things.

However, when I try to add a new Entity Data Model for ADO.NET connection, this one that has already been made does not show up in the list of available data connections. The File in the System.Data.SQLite Database option is not even included in the list of connections, even if I subsequently proceed to establish a new connection.

I've tried using NuGet to install the entity package both individually and with the SQLite packages. The choice for SQLite simply won't show up, regardless of whether I install them or just the Entity model together with the aforementioned assembly.

I come to you for assistance after spending a frustrating amount of time googling and flooding this and finding just a small number of others that share my issue but have no answer that works for me.

After exhausting all other options, I believe my App.config file is the key. My looks like this:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite.EF6" />
      <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" />
    </DbProviderFactories>
  </system.data>
</configuration>

related issues:

System.data.sqlite 1.0.93 was used to generate the entity framework 6.1.1 model in the database initially.

http://sqlite.1065341.n5.nabble.com/Provider-not-showing-up-in-Net-Model-import-wizard-td75306.html

I used SQLite version 1.0.96.0, vs2012.NET 4.5, and entity 6.1.3.

I'm hoping someone can assist me.

1
10
5/23/2017 12:02:04 PM

Accepted Answer

ZZZ_tmp
9
3/27/2015 10:29:41 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow