DbProviderFactory with Npgsql?

.net postgresql mono dbproviderfactories
Earlz picture Earlz · Aug 2, 2010 · Viewed 15.3k times · Source

I have a project which I'm trying to port from SQL Server to PostgreSQL. I've got almost everything done I believe except for I can not get DbProviderFactory to work with Npgsql. 

Factory = DbProviderFactories.GetFactory("Npgsql");

yields

Unhandled Exception: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.

How do I fix this?

Answer

ANeves picture ANeves · Nov 8, 2013

Try defining a factory in your app.config:

<system.data>
  <DbProviderFactories>
    <add name="Npgsql Data Provider" invariant="Npgsql"
         description="Data Provider for PostgreSQL"
         type="Npgsql.NpgsqlFactory, Npgsql" />
  </DbProviderFactories>
</system.data>

Via http://fxjr.blogspot.pt/2013/06/npgsql-code-first-entity-framework-431.html

Related questions

Linq To Sql with PostgreSQL

Is it possible to use LinqToSql with PostgreSQL (preferably with Mono)? Can you recommend any articles where it described step-by-step?

Read More
What are the pros and cons of performing calculations in sql vs. in your application

shopkeeper table has following fields: id (bigint),amount (numeric(19,2)),createddate (timestamp) Let's say, I have the above table. I want to get the records for yesterday and generate a report by having the amount printed to cents. One way of …

Read More
INSERT data from Textbox to Postgres SQL

I just learn how to connect C# and PostgresSQL. I want to INSERT data from tb1(Textbox) and tb2 to database. But I don't know how to code My previous code is SELECT from database. this is my code private …

Read More