I have a multi layer application in which I have different projects for different purposes.
So lets simplify it and say I have:
- WebAPI Layer
With a simple hierarchy: Web references Logic references DAL
My DAL wants to know a connection string, of course different by envoriment (e.g. Dev / Test / Live Stage).
1) Where to store the connection strings? Store them in the DAL Project, because it is self organized and wants care about it's own things ("a database layer should know his connections") Or should I store them in the web project because it is the leading start project for my application?
2) What is the best strategy to load different json-configs (web) or application configs (class lib DAL) by envoriment in DotNet Core?