I’m no fan of Microsoft (they made me pair program and it did me serious lasting harm) but I will defend that connection string. It’s in the web.config for an ASP project since it has to be editable to shift from staging to production on deployment. A lot of configuration stuff is in that file, and the design is sensible.
HOWEVER to not document it clearly is unforgivable but since when has Microsoft used documentation for anything but advertising?
I remember in 1995 I was writing a client app that talked with a server stub in DDE, Dynamic Data Exchange, which was the 16-bit world’s interprocess communication. It was on the way out, we were supposed to use OLE, which was almost immediately replaced by its underlying COM.
I needed a piece of information on one DDE message, WM_DDE_EXECUTE. I read one entry after another, useless, but every. Single. Entry. in the DDE documentation encouraged me to use OLE instead because it exposed a higher level of abstraction. I must have read that exact phrase 50 times, and it didn’t help me at all. The server stub used DDE. I finally called the company making the server and asked them. Turns out the message was unidirectional. The documentation never said that.