Switch connectiong string in web.config file base on configuration

[=?Utf-8?B?RGFuaWVs?=]

How can I switch connection strings stored in config file based on the build
configuration? Or my real question is how most people maintain different
connection strings when their code is running in different environment, like
development, building, testing....

Thanks.

Daniel

[Nicholas Paldino [.NET/C# MVP]]

Daniel,

Well, personally, I would have two separate config files (just like you
have two separate binaries) which have two separate connection strings.

You could have a preprocessor statement for a constant which sets
different values based on the build type. However, that means you would
have to put both values into your config file. That's a little hokey to me,
and it's easier to just have two config files, IMO, as you don't want to
distribute the debug connection string in the release file.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Daniel" <da*********@newsgroup.nospamwrote in message
news:88**********************************@microsof t.com...

How can I switch connection strings stored in config file based on the
build
configuration? Or my real question is how most people maintain different
connection strings when their code is running in different environment,
like
development, building, testing....

Thanks.

Daniel

[=?Utf-8?B?RGFuaWVs?=]

Thanks Nicholas. I think your approach can work. But for me, it's a little
bit inconvenient, as our application is still growing quickly, the config
file changes all the time, lots of stuffs from the enterprise library. Keep
two or more config files be synchronized could be error prone. Can I just
seperate a little part of the config file and make two of them to adopt
different configurations?

Daniel

[=?Utf-8?B?RGFuaWVs?=]

Thanks Steven, that's what I want.

Daniel

[Steven Cheng[MSFT]]

You're welcome!

Enjoy it! :)

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

[m.divyam]

On Aug 24, 6:22 am, Daniel <[e-mail]:

Thanks Nicholas. I think your approach can work. But for me, it's a little
bit inconvenient, as our application is still growing quickly, theconfig
file changes all the time, lots of stuffs from the enterprise library. Keep
two or moreconfigfilesbe synchronized could be error prone. Can I just
seperate a little part of theconfigfile and make two of them to adopt
different configurations?

Daniel

Hi Daniel,

i have another requirement. i need a config file in which i can define
appSettings.
but with the above one i am not able to do that..can you help me
regarding this.
if possible can you let me know how to define connection string
property also in the custom config file