Conditional Building and DSN

djmarquette · March 12th, 2004, 11:54 AM

I need to be able to connect to a development SQL Server when building "Debug" and to a production server when building "Release". Currently I have two DSN settings in AppSettings of web.config file, but I need to remember to use the change the code to point to the correct one when building.

Does someone have an example of how to have the code recognize, through the Build Configuration, to either use a development DSN or a Production DSN so that I can write this in code once and forget about it?

Thanks in advance for your help.

Imar · March 12th, 2004, 12:48 PM

Hi djmarquette,

You can make use of the debugging constant DEBUG. You can write code that runs in Debug mode and some other code that runs in Release mode.

You could use that to define a connectionstring, like this:

Code:

string connectionstring = "";
#if DEBUG
    connectionstring = "Debug";
#else
    connectionstring = "Release";
#endif

Instead of assigning the string directly, you could of course also retrieve it from a configuration file. Just define two connections with different names, and retrieve the appropriate one.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

djmarquette · March 12th, 2004, 04:11 PM

Thanks Imar. I was close, but your solution was exactly what I was looking for.