MySql.Data.EntityFrameworkCore vs Pomelo.EntityFrameworkCore.MySql

mysql entity-framework entity-framework-core asp.net-core-2.0 pomelo-entityframeworkcore-mysql
Harsh Sharma picture Harsh Sharma · Feb 9, 2018 · Viewed 10.9k times · Source

Which database connector should I use in .Net Core 2 enterprise level web app which is going to handle large amount of data.

I have two choices:

  1. Pomelo.EntityFrameworkCore.MySql
  2. MySql.Data.EntityFrameworkCore

But still confuse which one to choose for the development.

I started with MySql.Data.EntityFrameworkCore, which is MySQL official provider but after facing several issues while code first migration I had to google again for some better alternative.

After some research I found Pomelo.EntityFrameworkCore.MySql bit more helpful for my application and it also covered the issues I was facing before.

But it still left me a bit confuse about which one to choose for long term.

Pomelo is workign fine currently but I am not sure if they (pomelo team) will keep always keep it updating and will keep it in sync with the latest .Net Core version available in the market??

MySql is not working as expected but the only plus point with this is : It is provided by MySQl itself.

Please help me to decide

Answer

Related questions

EF Core - Table '*.__EFMigrationsHistory' doesn't exist

I want to stress out that this is .NET Core and the threads about EF 6.0 does not apply to this problem I created my DbContext and added it in DI, however when I do dotnet ef database update -v it …

Read More
Using MySQL with Entity Framework

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

Read More
mySQL DataSource on Visual Studio 2012

I've been reading about mySQL DataSource and the ability to use mySQL with Entity Framework, but I can't really generate EF with mySQL without the use of the DataSource Dialog How can I add mySQL Database to such dialog? This …

Read More