Offline - Online Connection Changing

Question

0.00/5 (No votes)

See more:

Hi All,

I have two connection string. one is server, another one is Local.

Whenever server connection fails , System has to work with local connection.

C#

public  static string fncGetConnection()
      {

          string sCurrentConnection = "";
          try
          {
              using (SqlConnection con = new SqlConnection(Server))
              {

                  con.Open();

                  sCurrentConnection = Server;
              }
          }
          catch (SqlException ex)
          {
              using (SqlConnection con = new SqlConnection(Local))
              {
                  con.Open();
                  sCurrentConnection = Local;
              }
          }

          return sCurrentConnection;

      }

I used above function to get the connection string. but it takes more time around(50 secs) to check the first connection string fails. how to speed up checking connection and using application with local connection?

Regards,
Pal.

Posted 17-Jun-12 18:27pm

palraj001

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jim Jos · Answer 1 · 2012-06-17T19:48:00

First time connection will always take long.. Creating a connection is expensive; it requires your application to connect to the database server, authenticate, and return a valid connection.

Subsequently connection takes less time as it caches some information.. but in your case the connection is a failure so every time you connect it will take the same time..

1. You could try connect during loading the application using a separate thread.. You will know whether the connection valid or not..

2. Somwhere before the user uses the connection you could do a quick check on the connection..

connection to a failed connection will always take time and you may not able to improve it that much..

Bernhard Hiller · Answer 2 · 2012-06-17T21:15:00

Solution 2

That's caused by the ConnectionTimeout value. You can change that in your connection string, e.g. by appending ;Connection Timeout=10

Posted 17-Jun-12 21:15pm

Bernhard Hiller