Bug #67852 Connector/Net nuget package error with EF 5
Submitted: 9 Dec 2012 23:41 Modified: 22 Feb 2013 3:32
Reporter: Jānis Ozols Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.6.4 OS:Microsoft Windows (7)
Assigned to: Assigned Account CPU Architecture:Any
Tags: Connector/Net, EF, entityframework, nuget

[9 Dec 2012 23:41] Jānis Ozols
Description:
Error in .NET Connector 6.6.4 added to Visual studio 2012 project via nuget package MySQL.NET https://www.nuget.org/packages/MySQL.NET

Using Entity Framework 5.0.0.0.

Error in MySqlMigrationSqlGenerator, running command Update-database.

Applying code-based migration: 201212092215380_Migration-Initial.
System.MissingMethodException: Method not found: 'System.DateTime System.Data.Entity.Migrations.Model.InsertHistoryOperation.get_CreatedOn()'.
   at MySql.Data.Entity.MySqlMigrationSqlGenerator.Generate(InsertHistoryOperation op)
   at MySql.Data.Entity.MySqlMigrationSqlGenerator.<.ctor>b__c(MigrationOperation op)
   at MySql.Data.Entity.MySqlMigrationSqlGenerator.Generate(IEnumerable`1 migrationOperations, String providerManifestToken)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, XDocument targetModel, IEnumerable`1 operations, Boolean downgrading, Boolean auto)
   at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.RunCore()
   at System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.Run()

How to repeat:
Using MS Visual studio 2012 and Entity Framework 5

Connector installed via nuget package 'MySQL.NET' 
https://www.nuget.org/packages/MySQL.NET

Follow this example:
https://blogs.oracle.com/MySqlOnWindows/entry/entity_framework_4_3_1

Suggested fix:
1) Make connector compatible to EntityFramework 5.0.0.0
2) Add nuget package (https://www.nuget.org/packages/MySQL.NET) dependency to exact version of EntityFramework 4.3.1
[12 Dec 2012 15:57] Re Porcello
this bug is related to the one i've reported:
http://bugs.mysql.com/bug.php?id=67773
[22 Jan 2013 3:32] Gabriela Martinez Sanchez
Hi J. Ozols:

Thanks for your interest and feedback on Connector/Net. This issue about the CreatedOn Column missing on the MigrationsHistory table is due to some changes done on EF 5. Which now it doesn't create the table with this column. We're close to get a new version which is supporting EF 5 and that doesn't have this problem.
Please we encourage you to check our forums(http://forums.mysql.com/list.php?38) and our blog (https://blogs.oracle.com/MySqlOnWindows/) where we'll  be doing the announcements of the release of this new version.

Thanks in advance.
[23 Feb 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".