Storing conn string in 3 tiered apps

[Guest]

Hello,
I am building an ASP.NET 2.0 app and would like to architect my app in 3
tiers, UI, BAL, and DAL. What is the recommended place to store the
connection string.

I only want the DAL to know the connection string. I tried putting it in
the web.config and using the ConfigurationManager.ConnectionStrings object
but my DAL is a separte dll from the ASP project so the compiler said it was
out of scope.

Are there any good samples out there where the logic is separated out into
three tiers instead of the classic data binding examples?

Thanks,
Vince

 

[Peter Rilling]

You have to include a reference to the correct assembly that has the
configuration code, then add the namespace (don't know what they are off the
top of my head by the documentation would have them).

 

[Guest]

Yes, that worked. Thanks

You have to include a reference to the correct assembly that has the
configuration code, then add the namespace (don't know what they are off the
top of my head by the documentation would have them).