6

I am using Visual Studio 2013 and it's up to date. I was in search of using a local database which doesn't require SQL Server to be installed on a client machine. I figured out that SQLite is the one that I should use, so I installed SQLite through NuGet. When I tried to create a data source from Server Explorer, I was expecting to see the System.Data.SQLite which was unfortunately not present.

All of the references and required files are included in my solution. I did all the steps, searched different forums and tried all but nothing worked. I also followed the steps that were present in Stack Overflow for the Visual Studio 2012 but none of them worked. What steps I should follow in order to use SQLite properly?

Improve this question
2
  • Check the last comment in this post: stackoverflow.com/questions/20060222/… Commented May 19, 2014 at 8:40
  • 2
    I used the 32 bit version of the sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe and the problem solved. Before that I was using the 64 bit version of it as my windows is 64 bit !. Thanks Commented May 19, 2014 at 8:55

1 Answer 1

Reset to default
6

I had a similar problem where I installed the System.Data.SQLite packages from Nuget, but the 'System.Data.SQLite Database File' option would not be listed as a data source.

In order to fix this problem, I ran through some of the steps from this blog post by Brecht Carlier. I fixed the issue by uninstalling the package, going to the official SQLite downloads page, searching for the 32-bit Windows (.NET Framework 4.5.1) Setup executable, which is the one labeled:

This is the only setup package that is capable of installing the design-time components for Visual Studio 2013.

Then I ran the executable, re-installed the System.Data.SQLite package through NuGet, and rebuilt the project. Everything seemed to work after that.

The problem seems to be that even if you're on a 64-bit machine, you need to download the 32-bit version. Hope this helps.

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

1 Comment

"The problem seems to be that even if you're on a 64-bit machine, you need to download the 32-bit version" what solved my problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.