disposing the objects 1

[compu66]

Hi all,

If I write cmd.connection.dispose()
In this only connection object gets destroyed ,or even command object also gets destroyed.

Thanks for any help in advance.

 

[jmeckley]

cmd.connection.dispose() will dispose of the connection. you still need to dispose of the command. use the using keyword to dispose of objects. this is a shorthand for try/finally blocks. example.
this

using (IDbConnection cnn = new SqlConnection())
{
   IDbCommand cmd = new SqlCommand("select * from foo", cnn);
   cmd.ExecuteReader();
}

equals this

IDbConnection cnn = new SqlConnection()
IDbCommand cmd = new SqlCommand("select * from foo", cnn);
try
{
   cmd.ExecuteReader();
}
finally
{
   cmd.Dispose();
   cnn.Dispose();
}

any objects declared within the using scope will be deallocated upon exiting the block.

Jason Meckley
Programmer
Specialty Bakers, Inc.