Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLite with Visual Studio 2012 and .NET 4.5?

Tags:

Is SQLite working with VS 2012 and .NET 4.5?

I installed it (System.Data.SQLite.x64) with NuGet and also installed a ado.net provider separately from this site (could only find one for .net 4.0), but it isn't showing up in the list of add-options in server explorer.

like image 483
Andreas Zita Avatar asked Jul 02 '12 09:07

Andreas Zita


People also ask

How do I add SQLite to Visual Studio?

Getting Started with SQLite from a .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.

Does SQLite support .NET core?

This tutorial uses SQLite because it runs on all platforms that . NET Core supports. For a list of available providers, see Database Providers.


1 Answers

There is now an official installer out on this page here:

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

It will install the design-time components into VS2012, as well as the official System.Data.Sqlite binaries.

There are many downloads on that page, the one you need is about half way down and you can get there by searching for this:

sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe

here is a direct link: http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe

PS: It is important to note that the design time components are not supported for VS Express due to licensing restrictions. (thanks Konrad)

like image 113
caesay Avatar answered Oct 20 '22 03:10

caesay