You’re adding the wrong path to PublicAdditionalLibraries, this should be the .lib file.
string LibraryName = Path.Combine(LibrariesPath, “sqlite3.lib”);
A link error means your header include is working fine but the methods were not found during linking, i.e. because the library was not found.