Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.
You would need a mapping provider for MySQL. That is an extra thing the Entity Framework needs to make the magic happen. This blog talks about other mapping providers besides the one Microsoft is supplying. I haven't found any mentionings of MySQL.
MySQL is hosting a webinar about EF in a few days... Look here: http://www.mysql.com/news-and-events/web-seminars/display-204.html
edit: That webinar is now at http://www.mysql.com/news-and-events/on-demand-webinars/display-od-204.html
Does anyone know when MySql will release a provider ? everywhere I look people are saying its coming. But this was a few months ago...
We all know that MS would like you to stay with MS SQL at all times. Don't expect so much support for anything except MS SQL for EF.
Update May-2010: It is funny people still downvoting this ;-) Now I am using EF4 with SQLite and it works great (btw: I wouldn't try with EF1).
This isn't about MS and what they want. They have created an *open system for others to plug-in 'providers' - postgres and sqlite have it - mysql is just laggin... but, good news for those interested, i too was looking for this and found that the MySql Connector/Net 6.0 will have it... you can check it out here:
http://www.upfromthesky.com/blog/post/2009/03/24/MySql-Supports-the-Entity-Framework.aspx
Check out my post on this subject.
http://pattersonc.com/blog/index.php/2009/04/01/using-mysql-with-entity-framework-and-aspnet-mvc-–-part-i/
Update: Get the latest version Connector/Net 6.2.3 (thank Brett)
History: It's been released - Get the MySQL connector for .Net v6.0 - this has support for Entity Framework
I was waiting for this the whole time, although the support is basic, works for most basic scenarios of db interaction. It also has basic Visual Studio integration.
Vintana,
Od course there's something ready now. http://www.devart.com/products.html - it's commercial although (you have a 30days trial IIRC). They make a living writing providers, so I guess it should be fast and stable. I know really big companies using their Oracle provider instead of Orace and MS ones.
This MySQL tutorial shows how to generate and use EF entities as a datasource for a control.
I didn't see the link here, but there's a beta .NET Connector for MySql. Click "Development Releases" to download 6.3.2 beta, which has EF4/VS2010 integration:
http://dev.mysql.com/downloads/connector/net/5.0.html#downloads