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?
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.
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.
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.
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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With