Hi all, what is the most correct way to save your connection string when using the n-tier approach ? right now i have two windows app and one web app using my DLL library, what i'm currently doing is to create a static
method inside my dal "GLOBALDAL"
inside i'm making this check :

Code:
if (System.Web.HttpContext.Current != null)
 ...
if httpContext.Current is null that's mean that one of my windows appliactions doing the request, if so i get the CN from a file otherwise it's mean its the website knocking on my door so i get the CN from:
Code:
 System.Web.HttpContext.Current.Application["ConnectionString"]

i thinking of changing it all and just set propery IN my DA layer that expose the CN as a string.

but I fear of security issues .... so what is the correct way?

thanks!