本文介绍了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>
这篇关于SQLite 1.0.94未出现在EDM提供程序上的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!