Can't use Postgres package together with Sqlite package in net9

[alex-zyl]

Looks like two packages conflicting, making it impossible to resolve sqlite server type.

STR:

1. Create net9 project that references EFCore.BulkExtensions.MIT.PostgreSql and set up DbContext
2. Create net9 unit-test project that references EFCore.BulkExtensions.MIT.Sqlite
3. In unit-tests project, configure DbContext to use Sqlite datasource and invoke library method like BulkInsertOrUpdateAsync()
4. Run unit-test

Upon executing the operation, SqlAdaptersMapping tries to call dbServerType = Type.GetType(efCoreBulkExtensionsSqlAdaptersText.SQLite.SqlLiteDbServer"); that returns null.

[videokojot]

Can please share the conflicting package and versions? Specifically versions of Postgre and Sqllite provider I'll try to create also NET9 version.

[alex-zyl]

Hi @videokojot

I was using version 8.17.0.

The actual issue is caused by adapter packages themselves and not their dependencies like npgsql or sqlite. The issue occurs because all adapter packages bring their own copies of adapter interfaces like IDbServer. To fix the issue, these abstractions need to be moved to a base/core package.

[videokojot]

I agree... current design is very bad, it should be refactored and move to core package as subdependency... PRs are always welcome..

Just FYI the NET9 version is out.