Database Migrations Problem

[pwarren]

I am using PostgreSQL with MVC4/EF4 and attempting to set up automatic migrations. Here are the steps I have taken:

* Run the Postgres CRMDemo succesfully
* Run my model and the database is created (I have to create the database manually first, but that's ok)
* Run the Enable-Migrations –EnableAutomaticMigrations command in Package Manager Console
* Configure postgres in my configuration.cs file:

Code: Select all

public Configuration()
        {
            AutomaticMigrationsEnabled = true;
            SetSqlGenerator(PgSqlConnectionInfo.InvariantName, new PgSqlEntityMigrationSqlGenerator());
        }

After that my project will not build:

Code: Select all

Error	1	Assembly 'Devart.Data.PostgreSql.Entity, Version=7.2.65.6, Culture=neutral, PublicKeyToken=09af7300eec23701' uses 'EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' which has a higher version than referenced assembly 'EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'	...\bin\Devart.Data.PostgreSql.Entity.dll	Roam

and 2 other PgSqlConnectionInfo conflicts.

* I tried the suggested redirect but to no avail:

Code: Select all

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
	<dependentAssembly>
	  <assemblyIdentity name="EntityFramework" publicKeyToken="b77a5c561934e089" />
				<bindingRedirect oldVersion="6.0.0.0" newVersion="4.4.0.0" />
	</dependentAssembly>
</assemblyBinding>

I cannot use EntityFramework 6 as I am limited to MVC4 in VS2010.

Anybody have automatic migrations working ?

Paul W

[Shalex]

Please make sure that:
1) you have downloaded CrmDemo.EFCodeFirst sample from http://blog.devart.com/entity-framework ... html#alldb
2) the project includes references to both
\Program Files\Devart\dotConnect\PostgreSQL\Entity\EF4\Devart.Data.PostgreSql.Entity.dll
\Program Files\Devart\dotConnect\PostgreSQL\Entity\EF4\Devart.Data.PostgreSql.Entity.Migrations.dll
also check via Debug > Windows > Modules that they are loaded in the process of application when debugging

If this doesn't help, send us a small test project for reproducing.

[pwarren]

I have managed to get this working now. Thanks for your pointers. The problem was that as I was publishing my project to a test server, I had added the Devart.Data.PostgreSql.Entity.dll to the bin folder. Following an abortive episode with EF5, I had to backtrack to EF4, and even though I was adding a new reference to the Devart EF4 dll, Visual Studio was picking up the one in my bin folder. I cleared out the bin folder and all the references, added them back and everything now works a treat.