In my experience, while it sounds nice to be able to swap out databases with just a config change, it really takes code changes even with an ORM. I recently wr

In my experience, while it sounds nice to be able to swap out databases with just a config change, it really takes code changes even with an ORM. I recently wrote an app that can use either SQLlite or MS SQL with EF Core. Many things are the same, but there are some queries that I have to handle differently between providers. If I were to add mongo or similar I’d definitely have more changes. I do choose the provider based on the connection string though :)