问题描述

我想在 VS2017 中使用 EF6 连接 sqlite.我安装了System.Data.SQLite"nuget 包.我还从 http://安装了sqlite-netFx46-setup-bundle-x86-2015-1.0.104.0.exe"system.data.sqlite.org，但添加 ADO.NET 数据实体时看不到 sqlite 提供程序.

I want to connect sqlite using EF6 in VS2017. I installed "System.Data.SQLite" nuget package. I also installed "sqlite-netFx46-setup-bundle-x86-2015-1.0.104.0.exe" from http://system.data.sqlite.org, but I cannot see the sqlite provider when adding ADO.NET data entity.

我错过了什么吗?或者上面的包不支持VS2017(据说是VS2015的)

Am I missing something? or the above package not supporting VS2017 (it said it is for VS2015)

推荐答案

VS 2017(目前)还没有 DDEX 提供程序包.https://system.data.sqlite.org/index.html/tktview?name=8292431f51

There is no DDEX provider package for VS 2017 (yet). https://system.data.sqlite.org/index.html/tktview?name=8292431f51

基本上你需要等待:sqlite-netFx46-setup-bundle-x86-2017-1.0.1xx.0.exe

Basically you need to wait for: sqlite-netFx46-setup-bundle-x86-2017-1.0.1xx.0.exe

官方"更新:

目前估计对 Visual Studio 2017 的支持将包含在 1.0.106.0 版本中，该版本应该在六月中旬的某个时间点.

The current estimate is that support for Visual Studio 2017 will be included in the 1.0.106.0 release, which should be released at some point in the mid-June timeframe.

mistachkin 于 2017-05-28 20:41:40 添加:在这一点上，我似乎不太可能为设计时组件(例如表设计器、实体向导等)添加 VS 2017 支持).

mistachkin added on 2017-05-28 20:41:40: At this point, it seems unlikely that I'll be able to add VS 2017 support for the design-time components (e.g. table designer, entity wizard, etc).

更新:我创建了一个 DDEX 提供程序，它在 Visual Studio 2017 中启用 SQLite 支持(仅适用于 EF6)，请参阅此处的操作指南:https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-提供者

UPDATE: I have created a DDEX provider that enables SQLite support (for EF6 only) in Visual Studio 2017, see the how-to guide here: https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider

这篇关于VS2017 中的 SQLite 提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！