13

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

nam
  • 21,967
  • 37
  • 158
  • 332

1 Answers1

17

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

Racil Hilan
  • 24,690
  • 13
  • 50
  • 55
  • But as demoed [here](http://geekswithblogs.net/danielggarcia/archive/2013/12/22/portable-databases-ii-using-sqlite-with-entity-framework.aspx) one should be able to use `SQLite Data Provider` in `Add New Data Source` wizard once you install `System.Data.SQLite (x86/x64)` using `Nuget Package Manager`. What could be missing here? – nam Dec 30 '17 at 20:34
  • 1
    It's not clear what version of VS that post was about, but considering that it was posted in 2013, perhaps it was for VS2012. Things have changed a lot in VS2017, so don't look at posts for other versions and think it will work the same for VS2017. If it were as simple as installing the NuGet package, ErikEJ and Devart wouldn't have wasted their time creating providers. There was a request for an official provider, but the request has been closed with no provider. You probably can reopen it or create a new request. – Racil Hilan Dec 31 '17 at 05:20
  • 8
    I have some additional advice here: https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider – ErikEJ Dec 31 '17 at 13:05
  • 1
    @RacilHilan Thank you for answering my question: "What could be missing here?" and clearing my confusion. – nam Dec 31 '17 at 15:49
  • 1
    @ErikEJ Your [link](https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider) further cleared my confusion on why we need a third party tool here for my case of VS2017 and EF. Thank you. – nam Dec 31 '17 at 15:53
  • Note that neither of those tools support DataSets. – j riv May 22 '18 at 04:57
  • @ErikEJ your link, to own toolbox, clearly shows that "some" `System.Data.Sqlite Database File` should appear. But after following the instructions only an "SQLite Provider (Simple for EF6 by ErikEJ)" is added which, of course, cannot be used as "Data Source" (about which is the question - `Add New Data Source`). – ilias iliadis Feb 22 '19 at 09:45