'How to migrate from MySQL.EntityFrameworkCore to Pomelo.EntityframeworkCore

I've got a production system that I'd like to migrate from using MySQL.EntityframeworkCore to Pomelo.EntityFrameworkCore. I wanted to do some due diligence before I just upgraded the nuget packages and give it a spin. I appreciate any insight. Currently I'm on EF5, also planning on upping to EF6.

One area of concern is existing migrations. Will they be compatible? Early in the project I switched from MSSQL provider to MySQL and had to delete and regenerate the migrations from scratch.

entity-framework-corepomelo-entityframeworkcore-mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

.Net Core 3.0 possible object cycle was detected which is not supported

ASP.NET Core: Error while Updating Migration (Database first approach)

The required library libhostfxr.so could not be found. Netcore Linux

Unable to resolve service for type Microsoft.EntityFrameworkCore.DbContextOptions

.net core injecting and resolving services

How to get only specific tables to create models from database with Entity Framework Core in C#

How to customize migration generation in EF Core Code First?

The required column was not present in the results of a 'FromSql' operation

How to set threading mode in SQLite with Entity Framework?

Entity Framework Core error "Column names in each table must be unique"

Entity Framework Long Timeout on Queries from Azure PostgresSQL DB

Add entity data model (edmx file) to .net core API

What would cause a for / foreach loop to break without explicitly calling a break?

SQLite Error 14: 'unable to open database file' with EF Core code first

Include all navigation properties using Reflection in generic repository using EF Core