CODEWITHSUNDEEP
c#asp.net-mvc
InfinityGoesAround
InfinityGoesAround

Reputation: 1021

How to compare two connectingstrings in C#

I have a default connectionstring and a Connectionstring in the webconfig, like this:

<add name="BAG_Zipcodes" connectionString="Password=;Persist Security Info=True;
     User ID=sa;Initial Catalog=e;Data Source=" />

But if that connectionstring is not in webconfig. use this one:

ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName];

So I compare it like this:

var zipcodeConnection = ConfigurationManager.ConnectionStrings["BAG_Zipcodes"];
            //zipcodeConnection = ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName];

if (zipcodeConnection == ConfigurationManager.ConnectionStrings["BAG_Zipcodes"] && zipcodeConnection != null)
    zipcodeConnection = ConfigurationManager.ConnectionStrings["BAG_Zipcodes"];

else if (zipcodeConnection == ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName] && zipcodeConnection != null) 
    zipcodeConnection = ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName];

But If I delete this connectionstring from webconfig: add name="BAG_Zipcodes

then the connectionstring is always null.

Thank you

Upvotes: 1

Views: 147

Answers (2)

InfinityGoesAround
InfinityGoesAround

Reputation: 1021

Oke, I solved like this:

var zipcodeConnection = ConfigurationManager.ConnectionStrings["BAG_Zipcodes"];


if (zipcodeConnection == ConfigurationManager.ConnectionStrings["BAG_Zipcodes"] && zipcodeConnection != null)
    zipcodeConnection = ConfigurationManager.ConnectionStrings["BAG_Zipcodes"];

else if (zipcodeConnection == null) 
    zipcodeConnection = ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName];

Upvotes: -1

Curtis
Curtis

Reputation: 103388

This can be done by using a coalesce statement.

var zipcodeConnection = (ConfigurationManager.ConnectionStrings["BAG_Zipcodes"])
                      ?? ConfigurationManager.ConnectionStrings[DbSchema.DefaultConnectionName];

Upvotes: 3

Related Questions