SQLite连接未显示在实体数据模型向导中

本文介绍了SQLite连接未显示在实体数据模型向导中的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

What i did to get where i am: I installed the assembly from system.data.sqlite/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 go.microsoft/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

sqlite.1065341.n5.nabble/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工具 - 从这里下载： www.microsoft / en-us / download / details.aspx？id = 40762

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