Swapping to MySQL from SQL Server 2008 with ASP.NET MVC, LINQ and Entity Framework

Question

I am considering migrating from SQL Server 2008 to MySQL to save on licencing costs.

I was wanting to know if this would work and what sort of problems it might cause.

As I used EF Code first for the database, my databse is automatically generated based on my class structure. Would this, the entity framework and LINQ still work with a MySQL database?

http://stackoverflow.com/questions/76488/using-mysql-with-entity-framework is pretty old but has some relevant info — Preet Sangha, Aug 08 '13 at 04:09

score 1 · Accepted Answer · edited May 23 '17 at 12:20

1

Yes EF and LINQ works with MySQL as well, please take a look at these posts.
Entity Framework 5.0 code-first with MySQL Connector 6.6.5.0 on .Net 4.5
and
MySql and Entity Framework Code First

edited May 23 '17 at 12:20

Community

1
1

answered Sep 04 '13 at 07:14

Sai

159
1
9

Swapping to MySQL from SQL Server 2008 with ASP.NET MVC, LINQ and Entity Framework

1 Answers1