Installing Sqlite Nuget Package Installs The Package But The Reference Is Not Available. Vs2019 Community

I'm writing a c# application using SQLite and I need the the SQLite Reference. Using NuGet I locate the package and the output window shows a successful install. Looking at the pa

Solution 1:

Installing SQLite NuGet Package installs the package but the reference is not available. VS2019 Community

I assume you have installed sqlite version 3.13.0 nuget package.If so, it is the behavior of this nuget package. This package is very special in that it is a transactional SQL database engine that implements self-contained, serverless, zero-configuration.

In simple terms, it is a configuration function package that operates on related data when the project is running, rather than a package that provides a reference class library for the project.

Let me explain it in more detail:

This is the content of the nuget package sqlite version 3.13.0

Note that each folder provides specific functionality for the installation project. And the function of the lib folder is to add its content(xxxx.dlls) as reference to a new project. In a word, Only the Dlls in lib folder can be recognized by nuget and added into Reference.

You can refer to this link for more detailed info about the function of the folders.

Second, there is a file called SQLite.props in the Build folder. The file will do some configuration to your project during build process.

In it, you can see these files:

<ContentInclude="$(MSBuildThisFileDirectory)..\..\runtimes\win7-x64\native\*"><Link>x64\%(Filename)%(Extension)</Link><CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory><Visible>False</Visible></Content></ItemGroup><ItemGroupCondition=" (Exists('packages.config') Or Exists('packages.$(MSBuildProjectName).config')) And '$(Platform)' == 'x86'"><ContentInclude="$(MSBuildThisFileDirectory)..\..\runtimes\win7-x86\native\*"><Link>%(Filename)%(Extension)</Link><CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory><Visible>False</Visible></Content></ItemGroup><ItemGroupCondition=" (Exists('packages.config') Or Exists('packages.$(MSBuildProjectName).config')) And '$(Platform)' == 'x64'"><ContentInclude="$(MSBuildThisFileDirectory)..\..\runtimes\win7-x64\native\*"><Link>%(Filename)%(Extension)</Link><CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory><Visible>False</Visible></Content>

So when you build your project, the SQLite.props file will be executed and they will provide services during build or at the runtime.

All of these indicates it is a package for specific execution functions rather than a nuget package for adding reference libraries to the project.

Suggestion

As a suggestion, you could install System.Data.SQLite in your project. And this nuget package provides the dlls which you want in Reference.

Hope it could help you.