CODEWITHSUNDEEP
sqlitevisual-studio-2017entity-framework-core
nam
nam

Reputation: 23749

SQLite Data Provider is missing in Visual Studio 2017

Using Nuget Package Manager I installed System.Data.SQLite (x86/x64) in VS2017. That resulted in installing the following packages as well:

System.Data.SQLite
System.Data.SQLite.EF6
System.Data.SQLite.Core

But as shown in image below, the Add New Data Source dialog box does not show the SQLite Data Provider:

enter image description here

Upvotes: 13

Views: 12883

Answers (1)

Racil Hilan
Racil Hilan

Reputation: 25351

The NuGet package is for your project and does not include a provider. For that, you need to install a DDEX provider package. There doesn't seem to be an official SQLite DDEX provider package for Visual Studio 2017, but you can try one of these two unofficial ones:

SQLite / SQL Server Compact Toolbox by ErikEJ

dotConnect ADO.NET Data Provider for SQLite by Devart Software

Upvotes: 17

Related Questions