Using block for SQLConnection in C#

Published on July 14, 2013 by abundantcode

Filed under C#

Last modified July 14, 2013

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3171 times

The using statement in C# can also be used to ensure that the resources are automatically cleaned before the using block exits.

One of the criteria of the Using statement is that the items being created in the using statement must implement IDisposable interface.

For example, you can use the using block to open the SQL Connection, retrieve the data.

Using block for SQLConnection in C#

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

namespace AbundantCode

{

internal class Program

{

//Using block for SQLConnection in C#

private static void Main(string[] args)

{

// var AbundantCodeVersions = new string[] { "AbundantCode v1", "AbundantCode v3", "AbundantCode v3", };

using (var conn = new SqlConnection(AbundantCode.GetConnectionString()))

{

conn.Open();

}

Console.ReadLine();

}

}

}
0saves
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


x

You might be Interested in these Posts

C# and Lambda - Finding all the elements of an integer array less than 35

Here's a sample code snippet demonstrating how to find all the elements of an integer array that is ...

C# and LINQ - Finding all the elements of an integer array less than 35

Here's a sample code snippet demonstrating how to find all the elements of an integer array that is ...

How to get the Number of Elements in an Array in C# ?

You can use the Length property of the array to return the number of elements in it. Note that once ...