Pomelo.entityframeworkcore.mysql: Why Choose This?

[ronnieoverby]

Apologies if there's a better channel in which to ask this. I think it would be useful if you included a comparison of this provider to some of the others. Microsoft's EFCore documentation mentions 4 different MySql providers:

-Official MySql,
-Pomelo
-Sapient Guardian Fork
-DevArt

I'm interested in knowing the differences, but I haven't found any resource that gets into that.

[caleblloyd]

I have structured the performance tests to work with other providers. Our strongest feature is that we are (as of 1.0.1) backed by MySqlConnector, which is truly asynchronous.

• Official MySql: this hits bugs in the performance tests, not sure why
• Sapient Guardian: I tried this months ago and couldn't get migrations to work. I'll try again soon, I see there have been changes
• DevArt: Pay for and closed source, I can't test it

I would love to post comparisons, but Pomelo is the only one that has worked reliably for me out of the box. Maybe once the others catch up we can post comparisons

[yukozh]

In another hand, we are following the Microsoft milestones, We have released our libs which based on ef core 1.0.0/1.0.1/1.1.0-preview1, but the other providers did not.

[yukozh]

Devart is not a .net standard lib, so it does not cross plat.

[Mats391]

Licenses are also different for each, in case that is relevant to you.
Official is GPL2
Pomelo is MIT
Sapient is GPL2 I think
DevArt isnt free

[VaclavElias]

Thanks, this is very helpful! :)

[mguinness]

I haven't used Pomelo yet, but I may try it due to issues with the others listed below:

Official MySql - no Take() support (https://bugs.mysql.com/bug.php?id=82991) and not compatible with 1.1.0 yet.
SapientGuardian - DateTimeOffset bug (https://github.com/SapientGuardian/SapientGuardian.EntityFrameworkCore.MySql/issues/32) and migrations issues.

Overall, no MySql provider gives full EF7 support yet (none support database scaffolding at this time) so the situation is rather confusing. Hopefully this will improve over time, but it's unfortunate that Oracle hasn't created a repo for MySql.Data.EntityFrameworkCore in GitHub.

[caleblloyd]

it's unfortunate that Oracle hasn't created a repo for MySql.Data.EntityFrameworkCore in GitHub.

It's part of their Connector/NET project. They have it on GitHub, but I don't think that it's fully up-to-date. The best place to get their source code is on their website and choose "Development Releases"

Oracle's connector works off a closed development roadmap, fairly restrictive license, and I'm not even sure if they accept Pull Requests from outside developers for features.

Pomelo is full MIT License and we accept Pull Requests! We plan to add scaffolding support eventually, but if someone wants to step in and contribute scaffolding support it could get done even sooner!

[yukozh]

@mguinness, @caleblloyd, @Schaussi

Now, we are the world first support scaffolding at this time(MySQL). Scaffold supports has been shipped in 1.1.0-rtm-10003.

[yukozh]

[yukozh]

Close this since it was out of date.