Unclear or missing directions on EF migrations in Aspire

[TheLever]

Clear documentation needed

I am searching for directions on how to add migrations to an aspire solution consisting of several services and a couple of different databases. I have seen several solutions and all of them fail presently with a missing database provider when attempting to add the migration using the CLI.

I have seen several of sample code provided, some add the migrations to the migration service, some to the library that has the context. I have also seen a comment indicating that the missing database provider could tricked by adding a dummy connection string in an appsettings.json, but it is not entirely clear where that should be put (tried it in both the app host and in the service consuming the database context).

Would it be possible to create some clear documentation which illustrates how this is solved?

This used to work for me as I have an Aspire app which makes use of migrations, and uses the migration service taken from the samples. There used to be an article describing step by step what to do (like in the Package Manager console, select this startup project etc), but I can't seem to find it again.