System.Data.Sqlite not being recognized by Visual Studio 2010 on Win 2K8 Server machine

Question

I have a Windows Server 2008 (64-bit) box that I am doing development on. I've installed Visual Studio 2010 and System.Data.SQLite (from sqlite.phxsoftware.com). My problem is that the former is not seeing the latter. That is, when I go to the Server Explorer in Visual Studio and select "Connect to Database" and the "Choose Data Source" window appears, SQLite does not appear under the list of data sources. Anyone know what the deal is with that? Could it be an issue with Windows Server 2008 because in the past I've no issues with VS 2010 + System.Data.Sqlite on a Windows 7 box.

Update: System.Data.SQLite and System.Data.SQLite.Linq assemblies are showing up in my GAC

Answer 1

EDIT - 2018-06-15: Updated non-working link, and changed answer to reflect improvements over the years with managing project dependencies.

---

I had the exact same issue...and just ran across this blog that has a workaround:

Original link (considered obsolete by author): http://www.tsjensen.com/blog/post/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions

New link (still relevant): http://www.tsjensen.com/blog/post/2012/11/10/SQLite-on-Visual-Studio-with-NuGet-and-Easy-Instructions

TL;DR: Use the System.Data.SQLite(x86/x64) Nuget package.