hadn't seen 'using' here before

[Guest]

hey all,

i've never seen "using" in the following context before, could someone
please explain:

static void Main()
{
string queryString =
"SELECT CategoryID, CategoryName FROM dbo.Categories;";
using (SqlConnection connection = GetConnectionString())
{
...

}

thanks,
rodchar

 

[Jon Skeet [C# MVP]]

i've never seen "using" in the following context before, could someone
please explain:

static void Main()
{
string queryString =
"SELECT CategoryID, CategoryName FROM dbo.Categories;";
using (SqlConnection connection = GetConnectionString())
{
...

}

The "using" statement is basically a try/finally block which calls
Dispose on whatever you create in the ( ) part. So the above is (very
roughly) equivalent to:

SqlConnection connection;
try
{
connection = = GetConnectionString();
....
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}

 

[Alberto Poblacion]

i've never seen "using" in the following context before, could someone
please explain:
using (SqlConnection connection = GetConnectionString())
{

It's a shorthand for creating the connection in a try...finally block,
and calling connection.Dispose() in the "finally" section. "using" can be
used in this way with any class that implements IDisposable (such as
SqlConnection) to ensure that Dispose gets called, while keeping the source
code clean and readable.

 

[Guest]

Thank you all for the help.

It's a shorthand for creating the connection in a try...finally block,
and calling connection.Dispose() in the "finally" section. "using" can be
used in this way with any class that implements IDisposable (such as
SqlConnection) to ensure that Dispose gets called, while keeping the source
code clean and readable.

 

[Guest]

The proviso being that in .NET 2.0 unlike in 1.1, the object inside the using
( ... ) *must* implement IDisposable.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net