4

Is there a way to use EntityFramework 4.3 beta with migrations with MySql database? Can we use migrations with MySql Database? Is it possible to use incremental database development with EF code first without me touching the database

Ladislav Mrnka
  • 360,892
  • 59
  • 660
  • 670
hanskishore
  • 361
  • 1
  • 3
  • 11

1 Answers1

4

Theoretically yes. Practically you first need to get (or create yourselves) class derived from System.Data.Entity.Migrations.Sql.MigrationSqlGenerator which will be responsible for generating SQL for MySQL. Here is more about customizing (or rewriting) SQL generation.

You can also wait until developers of EF supporting ADO.NET providers include this feature to their packages. For example Devart already started work on their migrations support for thier Oracle, MySQL, PostgreSQL and SQLite.

Ladislav Mrnka
  • 360,892
  • 59
  • 660
  • 670
  • 2
    The support for Entity Framework Code First Migrations was added in the new versions of Devart dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite : http://www.devart.com/news/2012/dotconnects670.html . – Devart Jan 30 '12 at 09:24
  • thanks @Ladislav-mrnka.. I tried customizing but every time I get a new error.. May be I'll try devart.. – hanskishore Jan 30 '12 at 14:43