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

visual-studio-2010 windows-server-2008-r2 system.data.sqlite
eponymous23 picture eponymous23 · May 25, 2011 · Viewed 8.4k times · Source

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

Joe the Coder picture Joe the Coder · Jun 7, 2011

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.

Related questions

VS 2010 Publish using Web Deploy

I'm trying to deploy my ASP.NET MVC 3 web application using VS2010 Publish feature. I'm using Web Deploy as Publish method, but I'm getting this error: Error 1 Web deployment task failed.(Remote agent (URL http://192.168.1.11/MSDEPLOYAGENTSERVICE) could not be contacted. …

Read More
The type or namespace name could not be found

I have a C# solution with several projects in Visual Studio 2010. One is a test project (I'll call it "PrjTest"), the other is a Windows Forms Application project (I'll call it "PrjForm"). There is also a third project referenced by …

Read More
Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More