Which of the following actions will he perform to accomplish the task?

John works as a Web developer for HiTech Inc. He develops an application named MyApp by using Visual C# .NET. John uses a SQL Server database.

He writes the following code:

OleDbCommand cmd = new OleDbCommand();

cmd.CommandText = "UPDATE Employees SET Rank = ‘Senior’ WHERE Basic > 10000";

cmd.ExecuteNonQuery();

Now he wants to improve the performance of the program code.

Which of the following actions will he perform to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
A . Use database indexing.
B . Use an OleDbDataReader object to execute the program code.
C . Use a Cache object to execute the program code.
D . Use a SqlCommand object instead of an OleDbCommand object.
E . Use a stored procedure instead of the CommandText property.
F . Use the Prepare method on the OleDbCommand object before executing the program code.

View Answer

Answer: D,E