SQLite连接未显示在实体数据模型向导中 [英] SQLite connection not appearing in Entity Data Model Wizard

问题描述

我做了什么，我得到的地方：
我从 http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki 使用GAC和VS2012选项。

What i did to get where i am: I installed the assembly from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki using the GAC and VS2012 options.

我现在可以连接到现有的SQLite日期库或建立连接并创建一个新的SQLite数据库文件。

I can now make a connection to an existing SQLite datebase or make a connection and create a new SQLite database file.

出现在我的服务器浏览器和工作正常。
我可以从资源管理器中查看这个数据库并更改表等。

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.

但是，当我尝试添加一个新的 ADO.NET实体数据模型，此已建立的连接将不会出现在可用的数据连接中。
即使我继续进行新的连接， System.Data.SQLite数据库文件选项甚至不在选项列表中。

However, when i try to add a new ADO.NET Entity Data Model this already made connection will not appear in the available data connections. Even if i then proceed in making a new connection, the System.Data.SQLite Database File option is not even in the list of options.

我已经尝试单独或与SQLite包一起安装NuGet实体包。我试过不安装它们或只有Entity模型与前面提到的程序集组合，但SQLite的选项不会出现。

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.

在googled和溢出后这是一个令人沮丧的时间，并发现只有一个handfull的人，显示出与我一样的问题，但没有解决方案，为我工作，我来帮助你。

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.

经过我的努力，我怀疑它归结到我的 App.config 文件。
Mine看起来如下：

After all my efforts, I suspect it comes down to my App.config file. Mine looks as follows:

<?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>

类似的问题：

数据库首先创建实体框架6.1.1使用system.data.sqlite的模型1.0.93

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

我使用vs2012 .NET 4.5，SQLite 1.0.96.0版本，实体6.1.3

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

我希望有人能够帮助我。

I hope someone will be able to help me.

推荐答案

安装实体框架6.1.3工具 - 从这里下载： http://www.microsoft .com / en-us / download / details.aspx？id = 40762

Install the Entity Framwork 6.1.3 Tools - download from here: http://www.microsoft.com/en-us/download/details.aspx?id=40762

这篇关于SQLite连接未显示在实体数据模型向导中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！