Which code segment should you insert at line 04?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. You add the following store procedure to the database.

CREATE PROCEDURE GetSalesPeople
AS
BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone
FROM SalesPeople
END

You write the following code segment. (Line numbers are included for reference only.)

01 SqlConnection connection = new SqlConnection(“…”);
02 SqlCommand command = new SqlCommand(“GetSalesPeople”, connection);
03 command.CommandType = CommandType.StoredProcedure;
04 …

You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

A.
var res = command.ExecuteReader();

B.
var res = command.ExecuteScalar();

C.
var res = command.ExecuteNonQuery();

D.
var res = command.ExecuteXmlReader();

Explanation:
ExecuteReader Sends the CommandText to the Connection and builds a SqlDataReader.

SqlCommand Class
(http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx)