What is using?

[Paulo]

using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStrings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on a
starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStrings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
....

VS 2005 asp.net 2.0 C#

Thanks!

 

[Mark Fitzpatrick]

Using in this context allows for automatic displosal and garbage collection
of the objects.

 

[George Ter-Saakov]

http://davidhayden.com/blog/dave/archive/2005/01/13/773.aspx

George

 

[IfThenElse]

Very good.

http://davidhayden.com/blog/dave/archive/2005/01/13/773.aspx

George

using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStrings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on
a starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStrings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...

VS 2005 asp.net 2.0 C#

Thanks!