You have been assigned the task of writing code that executes an Entity SQL query that returns
entity type objects that contain a property of a complex type. You need to fix line 12 –
Choose the correct line of code
01 using (EntityCommand cmd = conn.CreateCommand())
02 {
03 cmd.CommandText = esqlQuery;
04 EntityParameter param = new EntityParameter();
05 param.ParameterName = “id”;
06 param.Value = 3;
07 cmd.Parameters.Add(param);
08 using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
09 {
10 while (rdr.Read())
11 {
12
13 Console.WriteLine(“Email and Phone Info:”);
14 for (int i = 0; i < nestedRecord.FieldCount; i++)
15 {
16 Console.WriteLine(” ” + nestedRecord.GetName(i) + “: ” + nestedRecord.GetValue(i));
17 }
18 }
19 }
A.
ComplexDataRecord nestedRecord = rdr[“EmailPhoneComplexProperty”];
B.
DbDataRecord nestedRecord = rdr[“EmailPhoneComplexProperty”];
C.
DataSet nestedRecord = rdr[“EmailPhoneComplexProperty”] as ComplexDataSet
D.
DbDataRecord nestedRecord = rdr[“EmailPhoneComplexProperty”] as DbDataRecord;
Explanation:
How to: Execute a Query that Returns Complex Types
(http://msdn.microsoft.com/en-us/library/bb896329.aspx )
using (EntityConnection conn = new EntityConnection(ConfigurationManager.ConnectionStrings
[“StoreConnection”].ConnectionString))
{
using (EntityCommand comm = conn.CreateCommand())
{
// Here StoreConnection – ObjectContext name, Customers – correct DataSet name
comm.CommandText = “Select Customers.CustomerID, Customers.Name, Customers.Address
from StoreConnection.Customers where Customers.CustomerID=@qqqCustomerID”;
EntityParameter param = new EntityParameter(“qqqCustomerID”, DbType.Int32);
param.Value = 1;
comm.Parameters.Add(param);
conn.Open();
var reader = comm.ExecuteReader(CommandBehavior.SequentialAccess);
while (reader.Read())
{
DbDataRecord record = reader[“Address”] as DbDataRecord;
for (int i = 0; i < record.FieldCount; i++)
{
name.Text += “<br/>” + record.GetName(i) + ” : ” + record.GetValue(i).ToString();
}}
reader.Close();
}}