Trying to using EF 6 with PostgreSQL - Failed to find or load the registered .Net Framework Data Provider

c# entity-framework entity-framework-6 npgsql postgresql

Question

I am trying to use EF 6 Code First with Npgsql provider. When I try to run Add-Migration command in package manager I have the following exception: Failed to find or load the registered .Net Framework Data Provider.

PM> Add-Migration -Force -ConfigurationTypeName "TestDbContextMigration" -ConnectionString "Server=localhost;Port=5432;Database=test_db;User Id=test;Password=konnaya;" -ConnectionProviderName "Npgsql" 
cmdlet Add-Migration at command pipeline position 1
Supply values for the following parameters:
Name: 123
System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.
   at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.GetService(Type type, Object key, Func`3 handleFailedLookup)
   at System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.CachingDependencyResolver.<>c__DisplayClass1.<GetService>b__0(Tuple`2 k)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.Data.Entity.Infrastructure.DependencyResolution.CachingDependencyResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.<>c__DisplayClass3.<GetService>b__0(IDbDependencyResolver r)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.RootDependencyResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.<>c__DisplayClass3.<GetService>b__0(IDbDependencyResolver r)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver`2.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key)
   at System.Data.Entity.Internal.LazyInternalConnection.CreateConnectionFromProviderName(String providerInvariantName)
   at System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionStringSetting(ConnectionStringSettings appConfigConnection)
   at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
   at System.Data.Entity.Internal.LazyInternalConnection.get_Connection()
   at System.Data.Entity.Internal.LazyInternalContext.get_Connection()
   at System.Data.Entity.Infrastructure.DbContextInfo..ctor(Type contextType, DbProviderInfo modelProviderInfo, AppConfig config, DbConnectionInfo connectionInfo, Func`1 resolver)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, Boolean calledByCreateDatabase)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration)
   at System.Data.Entity.Migrations.Design.MigrationScaffolder..ctor(DbMigrationsConfiguration migrationsConfiguration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.ScaffoldRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Scaffold(String migrationName, String language, String rootNamespace, Boolean ignoreChanges)
   at System.Data.Entity.Migrations.AddMigrationCommand.Execute(String name, Boolean force, Boolean ignoreChanges)
   at System.Data.Entity.Migrations.AddMigrationCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
Failed to find or load the registered .Net Framework Data Provider.

The Update-Database command gives the same result.

Sources https://github.com/DonTomato/PgEF

This is a simple example that does not contain anything superfluous for this topic.

1
1
6/21/2014 11:08:19 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You need to have the Npgsql.dll, Mono.Security.dll and Npgsql.EntityFramework.dll assemblies added into the GAC as well as the following configuration added in the application's config file

<system.data>
  <DbProviderFactories>
    <remove invariant="Npgsql" />
    <add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql" type="Npgsql.NpgsqlFactory, Npgsql" />
  </DbProviderFactories>
</system.data>
<entityFramework>
  <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, Npgsql" />
  <providers>
    <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql.EntityFramework" />
  </providers>
</entityFramework>
0
1/6/2015 11:53:15 PM

Related Questions

'No Entity Framework provider found' for EF 6 and SQLite 1.0.96.0

Here is a working app.config...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Ve...
c# entity-framework entity-framework-6 sqlite
asked by Paul

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

That was a super-great answer zhnglicho! ...Another option, aside from placing the providers and DbProviderFactories into the app.config or web.config, is to code your ProviderFactories and use it in your implementation of DbContext....Usings:...using System.Data.Entity; using System.Data.Entity.Core.Common; using System.Data.Entity.ModelConfigurat...
c# entity-framework entity-framework-6 sqlite visual-studio-2013
asked by PixelSyndicate

ADO.NET provider with invariant name 'System.Data.SqlClient;' cannot be found (Entity Framework MVC)

I got this error but for me, it was something entirely different. I was able to solve it by looking at only ...Unable to find the requested .Net Framework Data Provider... and ...finding this answer.......I then had to edit:...C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config ...And:...C:\Windows\Microsoft.NET\Framework\v4.0.303...
.net asp.net asp.net-mvc entity-framework entity-framework-6
asked by Ogglas

How to make asp.net core rc2 (.net framework) work with EF 7 and .net 4.61

The CMD error that you're seeing is a ...bug... (See #...4797..., #...1858..., #...4555..., #...5392...). ...I managed to overcome this error during my migration to RC2 by restarting my computer (Fancy, I know). It seems to be fixed in the internal feed though, there's also a PR in #1858.
asp.net-core entity-framework-core
asked by Ivan Prodanov

How do I insert data into my database using Entity Framework .NET Core?

var dbOptions = new DbContextOptionsBuilder<YOURCONTEXT>() .UseSqlServer(connectionString: Environment.GetEnvironmentVariable("YOURCONNSTRING")) .Options; using (var yourDB = new YOURCONTEXT(dbOptions)) { }
c# entity-framework-core
asked by Askar Rayapov

MySQL - DBUpdateException ('Deadlock found when trying to get lock; try restarting transaction')

Can you try one more thing. Just a quick fix...//replace your line with this if (download == null) { context.SaveChanges(); scope.Complete(); throw new InvalidOperationException("Cannot find ProjectDownload.Id"); }
c# entity-framework-core mysql transactionscope
asked by Talha Akber

EF Core is lazy loading when I try to eager load with .Include()

Ok, after investigating the issue, there is a problem with EF Core 2.x lazy loading via proxies implementation. The related tracked issues are...#15170: Eager loading include with using UseLazyLoadingProxies...#12780: Store IsLoaded flags in proxy for better lazy-loading experience...The problem is that the navigation properties ...are... eager loa...
c# ef-core-2.2 entity-framework-core
asked by Ivan Stoev

Create nested data from JSON using .net core Entity Framework

If you want to create Group without User create a GroupPost class....public class GroupPost { public GroupPost(){ Users = new List<UserPost>(); } public string Name { get; set; } public List<UserPost> Users { get; set; } } public class UserPost { public string Name { get; set; } } [HttpPost] [ProducesResponseType(typeo...
.net .net-core c# entity-framework entity-framework-core
asked by Onur Åžahin

Oracle DB with .NET Core Using ODP.Net Provider - How to set the Schema

So, eventually I realized I was going about setting the Schema incorrectly. It seems that while the database connection had the correct Schema, Entity Framework may not have been aware of the correct Schema (or something like that). ...I found this answer on another post that set me straight: [...https://stackoverflow.com/a/35405309/3341533][1]..
.net-core entity-framework-core odp.net oracle
asked by BioData41

Load Related Data entity ef Core 3.1 using in Include

I conclude that there is a restriction on how deep you can go with ...ThenInclude... which is three level. So I work around it by calling ..._genderRepository... and pass ...GenderId... to get ...Gender... object however I don't think this is the best solution but it's easier than write ...sql... code....var newMethod = _depositRepository.All() ...
c# entity-framework entity-framework-core
asked by Abdul Hadi

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow