Could you please make `sqlite-net-static` load `e_sqlite3.dll` instead of `sqlite3.dll`, or make a new package `sqlite-net-static-esqlite3`

[viruscamp]

Could you please make sqlite-net-static load e_sqlite.dll instead of sqlite.dll or make a new package sqlite-net-static-esqlite3

If so , it need less packages install.

<PackageReference Include="sqlite-net-static-esqlite3" Version="1.10.196" />
<PackageReference Include="SourceGear.sqlite3" Version="3.50.4.5" />

[ericsink]

1. The whole purpose of sqlite-net-static is to invoke the sqlite DLL which is already assumed to be on the system.
2. I can't modify any nuget packages owned by @praeclarum until we adds me as an owner on nuget.org
3. Keeping the package reference for the native code separate from the C# wrapper is an intentional choice on my part. If the native code package is a transitive dependency, people keep asking for the the dependent package to be updated just to get new SQLite releases.

[viruscamp]

1. The whole purpose of sqlite-net-static is to invoke the sqlite DLL which is already assumed to be on the system.
2. I can't modify any nuget packages owned by @praeclarum until we adds me as an owner on nuget.org
3. Keeping the package reference for the native code separate from the C# wrapper is an intentional choice on my part. If the native code package is a transitive dependency, people keep asking for the the dependent package to be updated just to get new SQLite releases.

OK. I will keep the simple dependencies as above, and then add a PostBuildEvent to rename e_sqlite3.dll to e_sqlite.dll.

[ericsink]

Just in case I misunderstood... why do you need that name? I'm just curious.

[viruscamp]

I hate too many dependencies.

1. It just working, after install 2 packages: sqlite-net-static, SourceGear.sqlite3, and rename dll

<packages>
  <package id="sqlite-net-static" version="1.9.172" targetFramework="net472" />
  <package id="SourceGear.sqlite3" version="3.50.4.5" targetFramework="net472" />
</packages>

2. If I use sqlite-net-base, I have to install 2 packages: sqlite-net-base, SQLitePCLRaw.bundle_e_sqlite3, and got too many dependencies:

<packages>
  <package id="SourceGear.sqlite3" version="3.50.4.5" targetFramework="net472" />
  <package id="sqlite-net-base" version="1.9.172" targetFramework="net472" />
  <package id="SQLitePCLRaw.bundle_e_sqlite3" version="3.0.2" targetFramework="net472" />
  <package id="SQLitePCLRaw.config.e_sqlite3" version="3.0.2" targetFramework="net472" />
  <package id="SQLitePCLRaw.core" version="3.0.2" targetFramework="net472" />
  <package id="SQLitePCLRaw.provider.e_sqlite3" version="3.0.2" targetFramework="net472" />
  <package id="System.Buffers" version="4.6.1" targetFramework="net472" />
  <package id="System.Memory" version="4.6.3" targetFramework="net472" />
  <package id="System.Numerics.Vectors" version="4.6.1" targetFramework="net472" />
  <package id="System.Runtime.CompilerServices.Unsafe" version="6.1.2" targetFramework="net472" />
</packages>

3. sqlite-net-pcl ? It bound to the old binary SQLitePCLRaw.lib.e_sqlite3, which cannot be upgraded. And the denpendencies are like above.

[ericsink]

Ah, I see.

FWIW, another option is the package ID SQLite-net-e, but you'll still end up with the SQLitePCLRaw dependency which you are apparently trying to avoid.