establishing connection using ado .net

Question

Why do we use using keyword while establishing connection in C#.? Ex- using(connection con=new connection()) { // some ado .net code to access or insert/data . }

Amit Singh · Answer

hey 1. The reason for the using statement is to ensure that the object is disposed as soon as it goes out of scope and it doesn't require explicit code to ensure that this happens. 2. The using will take care of it for you. Under the hood SqlConnection.Dispose() calls the SqlConnection.Close() method and SqlCommand.Dispose() calls SqlCommand.Close() a using statement is syntactic sugar for a try ... finally that disposes the IDisposable object in the finally . 3. The using statement will call conn.Close() automatically due to the using statement (using ( SqlConnection conn = new SqlConnection(connString) ) and the same for a SqlDataReader object. And also if any exception occurs it will close the connection automatically. for Example : using ( MyResource myRes = new MyResource ()) { myRes . DoSomething (); } OR { // limits scope of myRes MyResource myRes = new MyResource (); try { myRes . DoSomething (); } finally { if ( myRes != null ) (( IDisposable ) myRes ). Dispose (); } } For more reference refer this link 1.http://www.c-sharpcorner.com/uploadfile/manas1/usage-and-importance-of-using-in-c-sharp472/

Khaja Moizuddin · Answer

As you are using connection class object you can use usingConnection or you can first set the namespace like using system.data.sqlclient; And within a class you can use Sqlconnection conn= new sqlconnection (); https://msdn.microsoft.com/en-us/library/ms971481.aspx#adonetbest_topic5 Refer this blog for usingConnection.

Salman · Answer

If we use using keyword then it will automatically dispose the Connection after execution complted.so there is no need to dispose your connection externally.Thanks.