Questions That Should Be Asked More Frequently

Q

Where should I store my connection strings?

A

That’s a bit of a loaded question. Some developers want to separate the connection string from the rest of the application in case they want to reconfigure the connection string without having to change the code in the application. Other developers’ primary goal is to keep the connection information a secret. To see how to accomplish either goal, read the next two Q&As.

Q

How should I store my connection strings to isolate them from the rest of the code in my application?

A

Configuration files are a great way to isolate this information from the rest of your application. They’re easy to create and modify using simple tools. The .NET Framework offers configuration ...

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.