While working on my personal blog upgrade, I ran into an edge case with Entity Framework migrations in .net 8. There is the ability in Entity Framework to support multiple database providers for a single database context. I'm using that in my personal blog's code. To support either Sqlite databases or SqlServer databases. I created a similar example of how to do this to help explain my edge case and made my request to Microsoft developers. I guess I'll see what they say! :)
In the meantime, the code in my sample app might be helpful for someone that wants to use multiple database providers with a single database context. That code is located here: https://github.com/anewton/dotnetStuff/tree/main/SeparateMigrationsIssue_EF
I submitted an Issue on the dotnet/efcore repository here: Support for a Single Project with Multiple Provider Migrations - Edge Case/Issue/Request
Sample code to support Sqlite or SqlServer