asp.net entityframework 4 - migrating SQL server to mysql

Question

any advice on this?

I built a db in sql server 2008 (only tables, no sp's and triggers) tables do use identity columns. In my asp.net app, i generated an EF model from the database. I use linq to talk to my entities. site works brilliantly.

what I want to experiment with (and stop me if I am speaking crazy talk) is to generate a new MySql db from the entity model, and config my app to use that instead, still using the same linq logic.

is this possible?

Thanks

Ladislav Mrnka · Accepted Answer · 2012-04-17 10:12:44Z

1

If you try it don't forget to backup your old EDMX file before you start playing with MySql. EDMX file consists of three parts where one is fully dependent on type of database server you are using. When you generate database from model, two parts of the EDMX file are completely replaced (including the database dependent part) so once you try to generate MySql database from the model your mapping to SQL Server will be lost (replaced by mapping to MySql database).

answered Apr 17, 2012 at 10:12

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Crudler Over a year ago

whew glad you told me that - well it would be in my source control but still. good to know!! thanks. is it worth expirimenting with? sqlserver hosting costs are quite high while the mysql is free but are their pitfalls in this approach. EF2MySql ? or should i just be biting the bullet. I can manage either or, but from a performance point of view is their any advantage to staying on the stack?

Ladislav Mrnka Over a year ago

It is up to you. SQL server and EF provider for SQL server are both MS products. Whole EF is created and tested to work with SQL Server and SQL Server CE. MySql provides its own provider for EF. You can try it, make some tests and see if it works with your application.

Collectives™ on Stack Overflow

asp.net entityframework 4 - migrating SQL server to mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related