Problems with SQLite and VS2013

Question

I've got a (hopefully) simple question. We're using Visual Studio 2013 and have a .Net 4.0 project. We would like to use a SQLite Database in this project. But all we can find are installations for VS2010 + .Net 4.0. If i Install this Version I cannot add a SQLite Connection in the Server Explorer view.

Is this in generall not possible or is there a way to add a SQLite Connection using VS2013 and .Net 4.0?

Thanks in advance

You need to add the SQLite-dll to References, and add a using SQLite to include the SQLite.cs file you also need. This will perhaps help you: CodeProject -> Using SQLite — Malte R
– Malte R, Commented Jun 19, 2015 at 9:09

Sébastien Sevrin · Accepted Answer · 2015-06-19 09:20:25Z

1

Here is the link to the SQLite package for .NET 4.5.1 with design-time components for Visual Studio 2013.

Unfortunately, as stated on the SQLite website:

This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of the System.Data.SQLite 1.0.97.0 (3.8.10.2) package. The Visual C++ 2013 Update 2 runtime for x86 is included. The .NET Framework 4.5.1 is required.
This is the only setup package that is capable of installing the design-time components for Visual Studio 2013.

So you would have to choose between:

Upgrade your project to .NET Framework 4.5.1
Use the SQLite dll for .NET Framework 4.0 and don't have the design-time components

answered Jun 19, 2015 at 9:20

Sébastien Sevrin

5,4132 gold badges25 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problems with SQLite and VS2013

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related