SQLite provider in VS2017

entity-framework sqlite visual-studio-2017

Question

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.

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

1
17
3/14/2017 5:12:47 PM

Popular Answer

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

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

"Official" update:

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 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).

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

27
5/30/2017 6:32:03 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow