22

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.

Improve this question
2
  • sqlite.1065341.n5.nabble.com/… this might be of interest. I can't fathom why they don't put nightly builds on the download page. Looks like we have to build the installer ourselves.
    – Hassan Syed
    Commented Dec 13, 2012 at 22:38
  • Please consider changing your accepted answer, as the answer from 10 Jul 2012 is now out-of-date.
    – Ryan Lundy
    Commented Mar 17, 2013 at 0:16

7 Answers 7

Reset to default
36

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)

Improve this answer
7
  • 3
    More specifically pick up sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe or search for the words Visual Studio 2012 since there are 56 (!!) possible downloads on that page and only one of them works with VS2012.
    – Lee Richardson
    Commented Feb 28, 2013 at 16:44
  • 2
    @LeeRichardson: Thanks for pointing out that it may be hard to find the correct one without searching or reading through them all.
    – caesay
    Commented Mar 2, 2013 at 0:55
  • Thank you so much for this answer. I have installed the above (x64) and was never prompted to install design-time components into my VS2012. SQLite was also not added as a data source. Is this a known issue? Apparently, after searching the downloads page for "Visual Studio 2012", it seems only the 32-bit version installs design time. Future reference for anyone that has the same issue.
    – Josh McKearin
    Commented Mar 2, 2013 at 3:54
  • 6
    Thanks for this answer. As noted above, installing x64 (logical if you're on a 64-bit system) does not install the VS 2012 design components. I nearly pulled my hair out trying to figure this out. The downloads page has bold text saying "This setup package is capable of installing the design-time components for Visual Studio 2012" next to the right download. If you don't see that text, you're downloading the wrong one.
    – Ryan Lundy
    Commented Mar 17, 2013 at 0:15
  • 1
    @caesay Due to Visual Studio licensing restrictions, the Express Editions can no longer be supported. (from the readme)
    – Konrad
    Commented Jul 10, 2013 at 14:51
5

I found another way to use sqlite with VS 2012, use dotConnect for SQLite, the standard free edition will work. http://www.devart.com/dotconnect/sqlite/download.html

Improve this answer
1
  • This did not work for me. although the controls appeared in visual studio it kept throwing errors.
    – caesay
    Commented Jun 21, 2013 at 21:44
4

For what it's worth, I have a patched designer installer executable that can install the wizard in VS2012 RC. You can download it here. You need to already have SQLLite installed, it needs to be version 1.0.66 (a slightly older version of the library), and it should go into the same directory that the original designer installer is at.

Assuming you used the default installation path, the executable should go into C:\Program Files\SQLite.NET\bin\Designer (for x86) or C:\Program Files (x86)\SQLite.NET\bin\Designer (for x64).

If the edition is checked in the listbox it has already (automatically) installed it in that version. If I had other visual studio versions on that machine, it would show them as well (2008 and later). The install is just a few registry entries and updating the machine.config file.

Improve this answer
2
  • I tried this, but it still doesn't appear in VS 2012 add connection list. The "bin\Designer" path doesn't exist for the latest .NET 4.0 version at system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki and "Visual Studio 2011" appears in the SQLite Designer Installation instead of 2012 (I'm running VS 2012 RC)
    – Andrew Gee
    Commented Aug 5, 2012 at 5:58
  • @AndrewGee - I see that. I just checked the version I am running, and I am not using the latest, unfortunately. I'm using 1.0.66, which I think is quite old, so this patch will only work for that version. I suppose that makes it a bit less useful for many people.
    – Christopher Currens
    Commented Aug 6, 2012 at 17:02
2

To install design time components for visual studio 2012, you need to install this binary package:

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

link to that page

The x64 version below it doesn't install the design time components. To access the design time components, go to (In vs 2012) View > Server Explorer, then right click, add new connection and then you will see add a sqlite database.

I am a beginner and getting this right ruined my night :(

Improve this answer
1
  • The reason I posted this answer was because it was never mentioned that the x64 won't install the design time components. I see now that there is a comment under your answer that mentions that. I should have just made it a comment though.
    – stirredo
    Commented Mar 19, 2013 at 14:26
0

The .NET 4.0 version should work fine with .NET 4.5. From what I can tell however, the current setup doesn't register the designer components with Visual Studio 2012.

So you can use it ...just not through any of the wizards yet.

Improve this answer
3
  • 1
    So when you say you can use it, you mean you can use sqlite not that you can manage database objects correct? I've got this all working but but I cannot see or modify my data once it is created. Do you have a work around for this?
    – Mike
    Commented Aug 11, 2012 at 14:41
  • @Mike, correct. I don't know a whole lot about database plugins, but I'm sure there are some registry keys you can manually copy from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\10.0 to 11.0 to get things working in VS 2012. I'd take a look at the setup's source if it's available. Proceed at your own risk. :)
    – bricelam
    Commented Aug 13, 2012 at 20:16
  • 2
    For anyone coming across this in the future, see @caesay's answer towards the bottom. VS2012 Design Time is now supported.
    – Josh McKearin
    Commented Mar 2, 2013 at 4:02
0

Here is form MSDN forum . The extension file was created by sqlite team , ready for vs2012

http://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e

Improve this answer
1
  • That package is made specifically for WinRT/Metro development. It is not useful if you are on a pre-windows 8 OS.
    – caesay
    Commented May 28, 2013 at 23:02
0

Hey i found a way to install and integrate the design components in vs2012 64 bits, hope this might help you folks out.

First download and install the sqlite bundle from: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

notice this bundle will install the dll's in your computer, however i does not integrate them to vs2012, that's why you cant see the SQLite option when you add a connection.

To integrate SQLite to VS you will need the 32 bit version of the bundle you downloaded previously (notice it says in the description in bold letters that that is the only file that can integrate the design components with VS).

Download the 32 bit version and run it, BUT!!! SELECT CUSTOM INSTALL, AND CHECK ONLY THE CHECKBOXES FOR CORE COMPONENTS (and it's two childs) AND VISUAL STUDIO DESIGNER COMPONENTS.

Go ahead and hopefully you will get SQLite integrated in your vs. GOOD LUCK!

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.