SQLite Data Provider is missing in Visual Studio 2017

entity-framework-core sqlite visual-studio-2017

Question

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

1
10
12/30/2017 5:45:45 PM

Accepted Answer

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

15
12/30/2017 6:02:33 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