SQLite 1.0.94未出现在EDM提供程序上 [英] SQLite 1.0.94 does not appear on EDM Providers

问题描述

我注意到这也是1.0.93的问题，但似乎也适用于1.0.94。

I noticed that this was an issue with 1.0.93, too, but it seems to also apply to 1.0.94.

更具体地说：

1. 机器运行Windows 8.1 x64，Visual Studio 2013


2. 安装sqlite-netFx451-setup-bundle-x86-2013 -1.0.94.0（来自SQLite官方网站）


3. 创建C＃.NET 4.5.1控制台项目


4. 添加NuGet SQLite x86 / x64


5. 向我的项目添加 ADO.NET实体数据模型


6. 从数据库中选择EF Designer


7. SQLite未在数据源提供程序下列出。

1. Machine runs Windows 8.1 x64, Visual Studio 2013
2. Install sqlite-netFx451-setup-bundle-x86-2013-1.0.94.0 from official SQLite website
3. Create a C# .NET 4.5.1 Console Project
4. Add NuGet SQLite x86/x64
5. Add an "ADO.NET Entity Data Model" to my project
6. Choose EF Designer from Database
7. SQLite is not listed under Data Source Providers.

相反，如果我在服务器下添加连接，则会出现SQLite提供程序资源管理器。但是，这还不够，因为我需要使用Entity Framework 6.1.1。

On the contrary, SQLite provider appears if I add the connection under Server Explorer. This is not enough, however, as I need to use Entity Framework 6.1.1.

如果有人对此有解决方案，请分享。谢谢。

If anyone has a solution to this, please share it. Thank you.

推荐答案

确保您的system.data部分如下所示：

Make sure your system.data section looks like this:

<system.data>
 <DbProviderFactories>
    <remove invariant="System.Data.SQLite" />
    <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>

这篇关于SQLite 1.0.94未出现在EDM提供程序上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！