views:

13551

answers:

10

Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.

A: 

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.

Lars Truijens
Yeah, you're right. I was hoping there's something ready right now.
vintana
+5  A: 

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

Sir Code-A-Lot
A: 

Does anyone know when MySql will release a provider ? everywhere I look people are saying its coming. But this was a few months ago...

Alexandre Brisebois
A: 

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).

twk
You are clueless. EF works perfectly with SQLite.
Frank Edwards
Postgres, Sqlite, MySql and MSSQL all work with EF.
bbqchickenrobot
Actually Microsoft even gave us their own sample provider for Oracle databases shortly after EF release. It was just a not-for-production sample but it still surpasses anything actually provided by Oracle to this day!
nvuono
ok, you got some of my reputation points, but switched my main project to EF4. We will se if in the future it would be easy to convert to any other database :)
twk
+3  A: 

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

I wonder what "initial" means when they said "Initial Entity Framework support".
vintana
+4  A: 

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/

pattersonc
+20  A: 

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.

Vin
Thanks for the update, I was waiting for the same thing!
Alexandre Brisebois
Thanks for the info!
Rich
I thought I'd mention that the latest version is available here (current 6.2.2): http://www.mysql.com/downloads/connector/net
Brett Ryan
Does this support EF4 and VS2010? I installed the connector and tried to add a new connection in VS2010 but MySQL does not show up in the list of providers
Abhijeet Patel
I'm curious about MySQL, EF4 and VS2010.
Vinicius
+3  A: 

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.

deadbeef
A: 

This MySQL tutorial shows how to generate and use EF entities as a datasource for a control.

Kasey Speakman
A: 

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

Brian Frantz