I’m working on a data synchronization API that currently works with MS SQL Server and PostgreSQL databases. Now I need to add MySQL support to give users more database choices.
I’m running .NET 9 and looking for a reliable Entity Framework provider for MySQL. The problem is that most packages I found seem to be outdated or only support older .NET versions like .NET 8.
Has anyone recently implemented EF Core with MySQL? What package did you use and how stable is it? I want to make sure I pick something that’s actively maintained and won’t break in future updates.
Any recommendations would be helpful since I don’t want to lock my users into just SQL Server.
MySqlConnector/MySqlConnector.EntityFrameworkCore is another solid choice. I migrated from SQL Server to MySQL last year with this provider - pretty smooth experience on .NET 8, though I haven’t tried .NET 9 yet. Documentation’s decent and they update regularly. Watch out for case sensitivity differences between MySQL and SQL Server - gave me headaches when table names wouldn’t match. Test your existing queries thoroughly since MySQL handles SQL syntax differently than SQL Server.
i’ve been using pomelo.entityframeworkcore.mysql for about 6 months now, and it’s been super reliable with .NET 9. no major issues, just a heads up on the connection string - it’s a bit different than the one for SQL Server.