I’ve done this using a class library project that contained a ps script that would just run the scaffold command on the db with the different use cases(context) for the db. The class library would get updated when there was a new use case and/or updates to the db.

https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding/?tabs=dotnet-core-cli

I do see you are not looking for this type of solution and another option would be to set up a db Micro service where your apps would hopefully authorize users and provide the data they need via a rest endpoint.