What is the difference between Connection Timeout and Command Timeout?( C# ADO.NET Interview questions with answers)

Connection Timeout –
How long it should take time to connect to server.

private voidCreateConnection()
{
stringconnectionString = “Data Source=(local);Initial Catalog=MyDB;”
        + “Integrated Security=SSPI;Connection Timeout=30”;
using (SqlConnection connection = newSqlConnection(connectionString))
    {
connection.Open();//If connection won’t get established within 30 seconds connection timeout error will be thrown
       }
}

Command Timeout –
How long a single command should execute.

private voidCreateConnection()
{
stringconnectionString = “Data Source=(local);Initial Catalog=MyDB;”
        + “Integrated Security=SSPI;Connection Timeout=30”;
using (SqlConnection connection = newSqlConnection(connectionString))
    {
SqlCommand command = connection.CreateCommand();
Command.CommandTimeout =40;
command.CommandText= “Select * from Table1”;
SqlDataAdaptersAdp=new SqlDataAdapter(command);
DataTableDt=new DataTable();
sAdp.Fill(Dt);//If query wont return result back in 40 seconds it will throw exception.
       }
}

How to set any of these values to infinite value?
Just set them to 0 (Zero).

Below is nice ADO.NET Interview question with answer video which explain dataset is a disconnected architecture and datareader is a connected architecture.

Advertisements

About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- https://www.youtube.com/watch?v=Lp7nSImO5vk Learn AngularJS Step by Step:- https://www.youtube.com/watch?v=0kmdjqgO9IY Learn Design Pattern in 8 hours:- https://www.youtube.com/watch?v=YDobmucohqk Learn C# and .NET in 60 days:- https://www.youtube.com/watch?v=yh2SrzCkNQA Learn MSBI in 32 hours:- https://www.youtube.com/watch?v=mGPJx3ocFgg Learn SharePoint Step by Step in 8 hours:- https://youtu.be/C2fW76SwJNU
This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

2 Responses to What is the difference between Connection Timeout and Command Timeout?( C# ADO.NET Interview questions with answers)

  1. why we set master page in preinit event in .net not in init ?

  2. why sql server have only one cluster index per table plz expalin me

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s