3.4 Entity Framework 6

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

3 Configuring the .NET Connector : 3.4 Entity Framework 6

3.4 Entity Framework 6

To set up .NET Connector for usage with Entity Framework 6, reference the shared library files located in the following directory:

C:\Program Files\edb\connectors\dotnet\4.5\

The shared library files are the following:

EnterpriseDB.EDBClient.dll

EntityFramework6.EnterpriseDB.EDBClient.dll

See Section 3.1 for information on referencing library files.

Add the <DbProviderFactories> entries for the ADO.NET driver of EDB Postgres in the app.config file. The following are the entries:

<add name="EnterpriseDB.EDBClient"

invariant="EnterpriseDB.EDBClient"

description=".NET Data Provider for EnterpriseDB PostgreSQL”

type="EnterpriseDB.EDBClient.EDBFactory, EnterpriseDB.EDBClient, Version=3.1.9.3, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"

support="FF"/>

In the project’s app.config file add the following entry for provider services under the EntityFramework/providers tag.

<provider invariantName="EnterpriseDB.EDBClient"

type="EnterpriseDB.EDBClient.EDBServices, EntityFramework6.EnterpriseDB.EDBClient">

</provider>

The following is an example of the app.config file.

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<configSections>

<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>

</configSections>

<startup>

<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

</startup>

<entityFramework>

<providers>

<provider invariantName="EnterpriseDB.EDBClient" type="EnterpriseDB.EDBClient.EDBServices, EntityFramework6.EnterpriseDB.EDBClient"></provider>

</providers>

</entityFramework>

<system.data>

<DbProviderFactories>

<remove invariant="EnterpriseDB.EDBClient"/>

<add name="EnterpriseDB Data Provider" invariant="EnterpriseDB.EDBClient" support="FF" description=".Net Framework Data Provider for Postgresql" type="EnterpriseDB.EDBClient.EDBFactory, EnterpriseDB.EDBClient"/>

</DbProviderFactories>

</system.data>

</configuration>

Note: The same entries for <providers> and <DbProviderFactories> are valid for the web.config file as well as for app.config.

Depending upon the type of application, import the namespace into the source code (see Section 3.1).

For usage of the features of Entity Framework 6, refer to the Microsoft documentation.

3 Configuring the .NET Connector : 3.4 Entity Framework 6