How to do Code first development with entity framework 6

How to do Code first development with entity framework 6

Postby kenalex » Tue 17 Jan 2017 20:53


I have just purchased the Professional version of the dotConnect Library for Postgresql with the intentions of moving from a MSQL database to Postgresql. My existing application was developed using Code First method with entity framework 6.
IN the documentation I see an example on how to perform code first for Entity Framework Core, but no examples for Entity framework 6 .

Is there an example on using code first method with DotConnect for Postgresql and Entity framework 6 that I can follow so I can get an understanding on how to setup the config file and what assemblies to import,etc ?
Posts: 2
Joined: Sat 24 Sep 2016 12:30

Re: How to do Code first development with entity framework 6

Postby Shalex » Thu 19 Jan 2017 13:11

Please refer to

You are using dotConnect for PostgreSQL v7.7.819 (check via Tools > PostgreSQL > About), aren't you? In this case:

1. The required assemblies are
* Devart.Data.dll v5.0.1611.0
* Devart.Data.PostgreSql.dll v7.7.819.0
* Devart.Data.PostgreSql.EF6.dll v7.7.819.0

2. The *.config file of the application should include
Code: Select all
<?xml version="1.0" encoding="utf-8"?>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
      <provider invariantName="Devart.Data.PostgreSql" type="Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices, Devart.Data.PostgreSql.Entity.EF6, Version=7.7.819.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
      <remove invariant="Devart.Data.PostgreSql" />
      <add name="dotConnect for PostgreSQL" invariant="Devart.Data.PostgreSql" description="Devart dotConnect for PostgreSQL" type="Devart.Data.PostgreSql.PgSqlProviderFactory, Devart.Data.PostgreSql, Version=7.7.819.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />

Replace 7.7.819.0 here with your actual version (two times).

Does this help? If not, specify the exact text of the error and its stack trace.
Devart Team
Posts: 7777
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for PostgreSQL