SQLite 1.0.94未出现在EDM提供程序上
问题描述：
我注意到这也是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.
更具体地说：
- 机器运行Windows 8.1 x64，Visual Studio 2013
- 安装sqlite-netFx451-setup-bundle-x86-2013 -1.0.94.0（来自SQLite官方网站）
- 创建C＃.NET 4.5.1控制台项目
- 添加NuGet SQLite x86 / x64
- 向我的项目添加 ADO.NET实体数据模型
- 从数据库中选择EF Designer
- SQLite未在数据源提供程序下列出。
- Machine runs Windows 8.1 x64, Visual Studio 2013
- Install sqlite-netFx451-setup-bundle-x86-2013-1.0.94.0 from official SQLite website
- Create a C# .NET 4.5.1 Console Project
- Add NuGet SQLite x86/x64
- Add an "ADO.NET Entity Data Model" to my project
- Choose EF Designer from Database
- 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>