Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

VS 2015 SQLite data provider

I'm using VS 2015 and i want to develop Win Form application with .NET Framework 4.5 and SQLite.

I have install the last "System.Data.SQLite" nuget package with all dependencies to my project but I couldn't find the SQLite data provider when I was trying to add a new connection to manage my database.

I try the solution for VS 2013 from here but don't works.

there is still no bundle for VS 2015, this is the problem? is any solution to use 2013 bundle in 2015, or other solutions?

like image 445
TotPeRo Avatar asked Feb 13 '15 20:02

TotPeRo


People also ask

What is SQLite provider?

Entity Framework Extensions EF6 - SQLite Provider. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. It is the most widely deployed SQL database engine and the source code for SQLite is in the public domain.

How do I add a SQLite database to Visual Studio?

Open Visual Studio, select new project, and, in Visual C#, select “Console Application” and provide the name as SQLiteDemo. Click OK. To connect SQLite with C#, we need drivers. Install all required SQLite resources from the NuGet package, as pictured in Figure 1.

What is System Data SQLite core?

System.Data.SQLite. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.


2 Answers

Installing this package: sqlite-netFx46-setup-bundle-x86-2015-1.0.103.0.exe should fix that. You need specifically 32-bit version

From http://system.data.sqlite.org/:

This is the only setup package that is capable of installing the design-time components for Visual Studio 2015.

This is working link at the time of writing http://system.data.sqlite.org/downloads/1.0.103.0/sqlite-netFx46-setup-bundle-x64-2015-1.0.103.0.exe

will add sqlite to the server explorer in VS2015

like image 177
Daniel Kreiseder Avatar answered Sep 22 '22 01:09

Daniel Kreiseder


For me, I had to install this package.

You have to check the second checkbox that will integrate SQLite into Visual Studio 2015 in the installation wizard.

The package Daniel showed us didn't work for me.

My configuration is this: VS 2015, from Nuget I installed Entity Framework 6, System.Data.SQLite.Core version 1.0.101, project is in .Net 4.6.1.

like image 23
JanBrus Avatar answered Sep 26 '22 01:09

JanBrus