MVC 5 with Visual Studio 2013 (Connection Strings in Repository Code when Deploying to Azure)

Question

My application works perfectly in that I work locally then publish to Azure, Code First handles all the database updates etc

However, I have a method in a class that does a SQL Bulk Copy and to get it working I used a hardcoded connection string

Now I need a neat way to have it 'auto switch' for me. So that when I deploy it automatically uses the LIVE Azure connection string and not the local database

i.e. here is an extract from the line I need to replace with say a application variable

Whats the neatest approach one could recommend for doing this :

            using (SqlBulkCopy sbc = new SqlBulkCopy(@"Data Source=WIN2008-VM;Initial Catalog=AscxxxCF;User Id=exxxer;Password=suxxnx;Integrated Security=True", SqlBulkCopyOptions.Default))
            {

timmkrause · Accepted Answer · 2014-01-23 13:02:27Z

2

What about using conditional compilation like

#if (DEBUG)
    // Local connection string.
#else
    // Azure connection string.
#endif

or Web.config transformations?

answered Jan 23, 2014 at 13:02

timmkrause

3,6815 gold badges37 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John · Accepted Answer · 2014-01-24 06:30:26Z

0

I used, this allowed me to detect within the URL if its running from localhost :

                string url = HttpContext.Current.Request.Url.AbsoluteUri;
                string sConnect = "";

                if (url.IndexOf("localhost") > -1)
                    sConnect = "Data Source=Wxxxx-VM;Initial Catalog=AscxxxxF;User Id=emxxxxr;Password=suxxxxc;Integrated Security=True";
                else
                    sConnect = "Server=tcp:zlxxxxxs.net,1433;Database=AscenxxxxDB;User ID=scoxxxxd;Password=Sxxx;Trusted_Connection=False;Encrypt=True;Connection Timeout=500;";

answered Jan 24, 2014 at 6:30

John

1,4994 gold badges23 silver badges47 bronze badges

Collectives™ on Stack Overflow

MVC 5 with Visual Studio 2013 (Connection Strings in Repository Code when Deploying to Azure)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related