System.Data.SQLite

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)

Please try adding the following line of code to your application and see if
the issue is still present:

Environment.SetEnvironmentVariable("TypeName_SQLiteProviderServices",
"System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6, " +
"Version=1.0.112.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139");

I'm sorry but this did not change anything -- still the very same error message.

I attached a sample to reproduce the exception.

Thanks for the example.  I'll investigate this issue as soon as I can.

Hello, OT here again (the one with the attachment at 2019-10-30 12:42:14 was a different person),

I wanted to note that years ago I got rid of all magic tokens inside app.config or .edmx files (meanwhile migrated to code first) by doing two things:

1) The class inheriting from DbContext only uses the ctor which passes in a read DbConnection instance. In my case this can be SQLServer or SQLite, determined at runtime by user settings.

2) There is one configuration class inside the same assembly inheriting from System.Data.Entity.DbConfiguration and doing the following inside the ctor:

	this.SetProviderFactory("System.Data.SQLite", System.Data.SQLite.SQLiteFactory.Instance);
	var providerServices = GetService<System.Data.Entity.Core.Common.DbProviderServices>(System.Data.SQLite.EF6.SQLiteProviderFactory.Instance);
	Debug.Assert(providerServices != null, "providerServices != null");
			this.SetProviderServices("System.Data.SQLite", providerServices);

Why and how this works I figured out using Reflection years ago. Might be outdated.