You use Microsoft .NET Framework 4 to develop an application. You write the following code to
update data in a Microsoft SQL Server 2008 database. (Line numbers are included for reference
only.)
01 private void ExecuteUpdate (SqlCoiranand cmd,
string connString, string updateStrnt)
02 {
03
04 }
You need to ensure that the update statement executes and that the application avoids connection
leaks.
Which code segment should you insert at line 03?
A.
SqlConnection conn = new SqlConnection(connString) ;
conn. Open ();
cmd.Connect ion = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery();
cmd.Connection.Close() ;
B.
using (SqlConnection conn = new SqlConnection(connString))
}
cmd.Connection = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
C.
using (SqlConnection conn = new SqlConnection(connString) )
{
conn.Open() ;
cmd.Connection = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery() ;
}
D.
SqlConnection conn = new SqlConnection(connString);
conn. Open ();
cmd.Connection = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery();
Explanation:
http://stackoverflow.com/questions/376068/does-end-using-close-an-open-sql-connection
http://www.w3enterprises.com/articles/using.aspx
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx