When using dbContext.Database.ExecuteSqlCommand or dbContext.Database.SqlQuery<T> the call just fails with the following stacktrace.

The same code works when targeting net48 (instead of netcoreapp3.0) or when using 1.0.111 (and ignoring the NuGet-restore warnings).

System.Data.Entity.Core.ProviderIncompatibleException
  HResult=0x80131920
  Message=A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'System.Data.SQLite.SQLiteConnection'. The store provider might not be functioning correctly.
  Source=EntityFramework
  StackTrace:
   at System.Data.Entity.Core.Common.DbProviderServices.GetProviderFactory(DbConnection connection)
   at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInvariantName(DbConnection connection)
   at System.Data.Entity.Internal.InternalConnection.get_ProviderName()
   at System.Data.Entity.Internal.LazyInternalContext.get_ProviderName()
   at System.Data.Entity.Internal.DefaultModelCacheKeyFactory.Create(DbContext context)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.Initialize()
   at System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(TransactionalBehavior transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(TransactionalBehavior transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(String sql, Object[] parameters)