Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config.

[rmsohailarshad]

I am designing Core 2.2 Web Api using Abp framework. I've setup App.Core, App.EntityFramework, App.Application. My goal is to expose App.Application & others to App.CoreWebApi project, and my clients uses only App.CoreWebApi which eventually deployed on some server. My clients includes multiple platforms mobile ui, web ui, and desktop ui. Everything is setup and in place but recieveing annoying error with database context class:

Message

Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config.

Stacktrace

at System.Data.Entity.Utilities.DbProviderFactoryExtensions.GetProviderInvariantName(DbProviderFactory factory) at System.Data.Entity.Infrastructure.DependencyResolution.DefaultInvariantNameResolver.GetService(Type type, Object key) at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory) at System.Linq.Enumerable.SelectArrayIterator2.MoveNext()
at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable1 source, Func2 predicate, Boolean& found) at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key) at System.Linq.Enumerable.SelectArrayIterator2.MoveNext() at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable1 source, Func2 predicate, Boolean& found) at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key) at System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver2.GetService(Type type, Object key) at System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key) at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInvariantName(DbConnection connection) at System.Data.Entity.Internal.InternalConnection.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.ForceOSpaceLoadingForKnownEntityTypes()
at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext() at Abp.EntityFramework.AbpDbContext.RegisterToChanges() in D:\Github\aspnetboilerplate\src\Abp.EntityFramework\EntityFramework\AbpDbContext.cs:line 148
at Hoorain.EntityFramework.HoorainDbContext..ctor(String nameOrConnectionString) in C:\Users\Admin\Downloads\Hoorain\4.1.0\src\Hoorain.EntityFramework\EntityFramework\HoorainDbContext.cs:line 34
at lambda_method(Closure , Object[] )
at Castle.Core.Internal.ReflectionUtil.Instantiate[TBase](Type subtypeofTBase, Object[] ctorArgs)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstanceCore(ConstructorCandidate constructor, Object[] arguments, Type implType)`

[ismcagdas]

@rmsohailarshad are you using EF 6 ?

[rmsohailarshad]

Yes.

[ismcagdas]

And is your project .NET Core ? If so, this is not supported yet, see dotnet/ef6#623 (comment)

[rmsohailarshad]

Following is the exact version I am using:
<package id="EntityFramework" version="6.2.0" targetFramework="net461" />

[ismcagdas]

I mean your project's target framework not the EF's version.
You can check value of TargetFramework item in your csproj file.

[rmsohailarshad]

It is Core 2.2

[acjh]

As mentioned by @ismcagdas, .NET Core does not support EF 6 yet.

[rmsohailarshad]

can I deploy my Hoorain.Application project as webapi, if I enable Dynamic Api?

[ismcagdas]

you need to deploy WebApi project, Hoorain.Application is a class library.

[rmsohailarshad]

@ismcagdas is there any help manual to configure Web Api 2?

[maliming]

@rmsohailarshad
You can refer to this https://github.com/aspnetboilerplate/module-zero-template