Your Microsoft SQL Server database has a stored procedure named GetCompanyName. GetCompanyName accepts one parameter named @CustomerID and returns the appropriate company name. You instantiate a SqlCommand object named myCommand. You need to initialize myCommand to return the company name for @CustomerID with a value of “ALFKI”. Which code segment should you use?

A.
myCommand.CommandText = “GetCompanyName, ALFKI”;
myCommand.Parameters.Add(“@CustomerID”);

B.
myCommand.CommandText = “GetCompanyName”;
myCommand.Parameters.Add(“GetCompanyName”, “ALFKI”);

C.
myCommand.CommandText = “@CustomerID”;
myCommand.Parameters.Add(“GetCompanyName”, “ALFKI”);

D.
myCommand.CommandText = “GetCompanyName”;
myCommand.Parameters.Add(“@CustomerID”, “ALFKI”);