SQLite provider in VS2017

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)

Answer 1

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