Issue to setup Sql Lite for the project

The project directory is the folder that contains the .csproj (or .fsproj) file for the ASP.NET/ASP.NET API project, not the bin folder.

Run the dotnet add package sqlite-net-pcl (or Microsoft.Data.Sqlite) command from the same folder where the project file lives, for example:

MySolution/
  MyApiProject/
    MyApiProject.csproj   <-- run dotnet commands here
    Program.cs
    appsettings.json
    bin/
    obj/

So:

1. Open a terminal/PowerShell.
2. cd into the folder that contains YourProject.csproj.
3. Run the dotnet add package ... command there.

Do not run it inside bin, obj, or any other build output folder.

References:

• Tutorial: Use a SQLite database in a Windows app
• Use a SQLite database in a UWP app