Connection String: Global.asax vs. web.config file

[D. Shane Fowlkes]

Upon reading through my ASP.NET book, I've learned how to place the
connection string in both locations in my application. Just due to habit, I
naturally want to place my SQL Server connection string in the asax
file...but are there really advantages to having in one file over the other?

Thanks

[Steve C. Orr [MVP, MCSD]]

Your web.config file is generally considered a better place because it's a
simple text file that is easily updated without needing to recompile
anything and changes go into effect immediately.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Upon reading through my ASP.NET book, I've learned how to place the
connection string in both locations in my application. Just due to habit, I naturally want to place my SQL Server connection string in the asax
file...but are there really advantages to having in one file over the other?
Thanks

[Jeremy]

I agree.

I use the web.config file because in our environment I
have to move an application from development to staging
(for testing) and then up to production. So rather than
making the change in the asax file and recompiling every
time before pushing the application up to the next stage I
just open the web.config and make the change.

I guess it's all just preference, whatever you feel most
comfortable in doing, but I vote for web.config

Jeremy

-----Original Message-----
Your web.config file is generally considered a better place because it's asimple text file that is easily updated without needing to recompileanything and changes go into effect immediately.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able- consulting.com
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in messagenews:%2****************@TK2MSFTNGP12.phx.gbl...

Upon reading through my ASP.NET book, I've learned how to place the connection string in both locations in my application. Just due to habit,

I

naturally want to place my SQL Server connection string

in the asax file...but are there really advantages to having in one

file over theother?

Thanks

.