CODEWITHSUNDEEP
entity-frameworksqlitevisual-studio-2017
Raymond Wong
Raymond Wong

Reputation: 312

SQLite provider in VS2017

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)

Upvotes: 18

Views: 27183

Answers (4)

Sameera Gunathilaka
Sameera Gunathilaka

Reputation: 11

The issue was solved after installing SQLite/SQL Server Compact Toolbox. Please try. https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox

Upvotes: 1

Pierre-Olivier Pignon
Pierre-Olivier Pignon

Reputation: 747

According to the url provided by the sqlite-netFX46-bundle-win32-2015-1.0.108.0 intaller log : https://system.data.sqlite.org/index.html/info/8292431f51119807241632b092774e60189018d9 Visual Studio 2017 support isn't available yet I tryied many things without any result, the worst is that I installed also a VS 2015 but cannot install because of the VS 2017 installation on my computer.

Upvotes: 0

ErikEJ
ErikEJ

Reputation: 41769

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

Upvotes: 28

Spacefish
Spacefish

Reputation: 96

The VS 2017 installer is really a pain in the b***.. Installing packages via an automated deployment works, but detecting installation state and such is near to impossible..

Seems like microsoft devs finally got sick of msi packages and implemented their own installer / package manager for VS2017, as other teams did for Office 365 and such..

Upvotes: 0

Related Questions