Using MySQL with Entity Framework [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 6 years ago.

Improve this question

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

frankly speaking, mysql support for LINQ is crap! I am banging my head on minor issues for last one week :| ... — effkay
– effkay, Commented Dec 25, 2009 at 7:04

NoWar · Accepted Answer · 2013-12-18 18:24:02Z

192

It's been released - Get the MySQL connector for .Net v6.5 - 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.

UPDATE http://dev.mysql.com/downloads/connector/net/ Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html).

edited Dec 18, 2013 at 18:24

NoWar

37.8k85 gold badges341 silver badges519 bronze badges

answered May 11, 2009 at 15:02

Vin

6,1754 gold badges45 silver badges57 bronze badges

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

10 Comments

Brett Ryan Over a year ago

I thought I'd mention that the latest version is available here (current 6.2.2): mysql.com/downloads/connector/net

Abhijeet Patel Over a year ago

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

Vinicius Rocha Over a year ago

I'm curious about MySQL, EF4 and VS2010.

David Anderson Over a year ago

It should if you have the latest connector. I just moved my product to .NET4 specifically because of MySQL Entity support. The tools and everything work okay, but the big issue is the underlying support it provides for actual querying. There's quite a few problems with lamba expressions that you don't run into with MSSQL

Nullius Over a year ago

Ofcourse, there are new versions coming out. Now supporting EF5, version 6.7.4: dev.mysql.com/downloads/connector/net/#downloads Also, Since this version, the VS plugin with MySQL server and other tools included is bundled in one package: dev.mysql.com/tech-resources/articles/…

|

kͩeͣmͮpͥ ͩ · Accepted Answer · 2011-04-18 13:57:35Z

21

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/

edited Apr 18, 2011 at 13:57

kͩeͣmͮpͥ ͩ

7,86229 silver badges41 bronze badges

answered Apr 3, 2009 at 3:12

pattersonc

1,29211 silver badges13 bronze badges

4 Comments

kͩeͣmͮpͥ ͩ Over a year ago

I fixed the encoding of that link - users can now click right through rather than have to copy/paste or select/goto

MüllerDK Over a year ago

Link doesn't work

Andy White Over a year ago

You can get to the articles with this link: pattersonc.com/blog/2009/04

user3508811 Over a year ago

Is using MYSQL with EF got any better or there are still issues?if SQL server is preferable can anyone pinpoint exactly why SQL server is preferable just because its the same vendor Microsoft?

Bill Karwin · Accepted Answer · 2008-12-09 18:29:01Z

10

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

edited Dec 9, 2008 at 18:29

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

answered Sep 28, 2008 at 13:20

Sir Code-A-Lot

5956 silver badges17 bronze badges

1 Comment

Arjun Vachhani Over a year ago

Link is not working.

bbqchickenrobot · Accepted Answer · 2009-03-25 00:27:54Z

7

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

answered Mar 25, 2009 at 0:27

bbqchickenrobot

1 Comment

vintana Over a year ago

I wonder what "initial" means when they said "Initial Entity Framework support".

Lars Truijens · Accepted Answer · 2008-09-16 20:32:12Z

5

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.

answered Sep 16, 2008 at 20:32

Lars Truijens

43.9k6 gold badges134 silver badges146 bronze badges

1 Comment

vintana Over a year ago

Yeah, you're right. I was hoping there's something ready right now.

aaimnr · Accepted Answer · 2009-11-06 11:36:00Z

2

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.

answered Nov 6, 2009 at 11:36

aaimnr

1,6261 gold badge18 silver badges31 bronze badges

1 Comment

Devart Over a year ago

Thank you for your response. @Vintana, you can find more information about dotConnect for MySQL and its advantages here devart.com/dotconnect/mysql. To improve your work with Entity Framework entities we provide an advanced tool for visual model creation - Entity Developer devart.com/entitydeveloper.

oware · Accepted Answer · 2013-10-11 15:24:04Z

1

Be careful using connector .net, Connector 6.6.5 have a bug, it is not working for inserting tinyint values as identity, for example:

create table person(
    Id tinyint unsigned primary key auto_increment,
    Name varchar(30)
);

if you try to insert an object like this:

Person p;
p = new Person();
p.Name = 'Oware'
context.Person.Add(p);
context.SaveChanges();

You will get a Null Reference Exception:

Referencia a objeto no establecida como instancia de un objeto.:
   en MySql.Data.Entity.ListFragment.WriteSql(StringBuilder sql)
   en MySql.Data.Entity.SelectStatement.WriteSql(StringBuilder sql)
   en MySql.Data.Entity.InsertStatement.WriteSql(StringBuilder sql)
   en MySql.Data.Entity.SqlFragment.ToString()
   en MySql.Data.Entity.InsertGenerator.GenerateSQL(DbCommandTree tree)
   en MySql.Data.MySqlClient.MySqlProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   en System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
   en System.Data.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree)
   en System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   en System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)
   en System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
   en System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
   en System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
   en System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
   en System.Data.Entity.Internal.InternalContext.SaveChanges()
   en System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   en System.Data.Entity.DbContext.SaveChanges()

Until now I haven't found a solution, I had to change my tinyint identity to unsigned int identity, this solved the problem but this is not the right solution.

If you use an older version of Connector.net (I used 6.4.4) you won't have this problem.

If someone knows about the solution, please contact me.

Cheers!

Oware

edited Oct 11, 2013 at 15:24

answered Apr 27, 2013 at 15:58

oware

72410 silver badges25 bronze badges

3 Comments

Dave Over a year ago

The error is thrown because p is null. You have to create a new empty instance of the object first. I.e. Person p = new Person(); not Person p; So: Person p = new Person(){Name = "Oware"}; context.Person.Add(p); context.SaveChanges();

oware Over a year ago

sorry I forgot to add the new line, even if I add the new line, the error stills appearing

Der_Meister Over a year ago

The bug is fixed in version 6.8.2. bugs.mysql.com/bug.php?id=70888 Connector/Net 6.8.3 is released. dev.mysql.com/downloads/connector/net

scotru · Accepted Answer · 2018-03-03 04:14:11Z

1

You might also look at https://www.devart.com/dotconnect/mysql/

DevArt's connector supports EF and MySQL.

edited Mar 3, 2018 at 4:14

answered Jun 5, 2011 at 7:20

scotru

2,60621 silver badges39 bronze badges

Comments

Brian Frantz · Accepted Answer · 2010-07-13 18:32:47Z

0

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

answered Jul 13, 2010 at 18:32

Brian Frantz

1

Comments

Igor Yalovoy · Accepted Answer · 2015-04-07 09:09:54Z

0

If you interested in running Entity Framework with MySql on mono/linux/macos, this might be helpful https://iyalovoi.wordpress.com/2015/04/06/entity-framework-with-mysql-on-mac-os/

answered Apr 7, 2015 at 9:09

Igor Yalovoy

1,7261 gold badge17 silver badges23 bronze badges

2 Comments

user3508811 Over a year ago

Is using MYSQL with EF got any better or there are still issues?if SQL server is preferable can anyone pinpoint exactly why SQL server is preferable just because its the same vendor Microsoft?

Igor Yalovoy Over a year ago

I am not sure how it is right now, but we had pretty bad experience due to lack of features and it being overall inconsistent. MS MSQL is definitely preferable, because Microsoft puts it's own stack first.

Collectives™ on Stack Overflow

Using MySQL with Entity Framework [closed]

10 Answers 10

10 Comments

4 Comments

1 Comment

1 Comment

1 Comment

1 Comment

3 Comments

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

10 Comments

4 Comments

1 Comment

1 Comment

1 Comment

1 Comment

3 Comments

Comments

Comments

2 Comments

Linked

Related