All geek questions in one place

System.Data.SQlite does not appear in Visual Studio 2013 change data source

I am using Visual Studio 2013 and am updating. I was looking for using a local database that does not require installing SQL Server on the client machine. I realized that SQLite is the one I should use, so I installed SQLite through NuGet. When I tried to create a data source from Server Explorer, I expected to see System.Data.SQLite, which, unfortunately, is not there.

All links and necessary files are included in my solution. I took all the steps, looked for different forums and tried everything, but nothing worked. I also followed the steps that were present in Qaru for Visual Studio 2012, but none of them worked. What steps should I follow to use SQLite correctly?

+6
source share
1 answer

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

To fix this problem, I looked through some steps from this Brecht Carlier blog . I fixed the problem by uninstalling the package, going to the official SQLite download page , looking for the 32-bit Windows (.NET Framework 4.5.1) Setup executable, which is as follows:

This is the only installation package that can install development-time components for Visual Studio 2013.

Then I ran the executable, reinstalled the System.Data.SQLite package through NuGet, and rebuilt the project. After that, everything worked.

The problem is that even if you are on a 64-bit machine, you need to download the 32-bit version. Hope this helps.

+5
source

Source: https://habr.com/ru/post/969503/

More articles:


All Articles