Microsoft TS: Accessing Data with Microsoft .NET Framework 4 : 70-516

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Plain Old CLR objects (POCO) to model your entities.
The application communicates with a Windows Communication Foundation (WCF) Data Services service.
You need to ensure that entities can be sent to the service as XML. What should you do?

• A. Apply the [DataContract(IsReference = false)] attribute to the entities.
• B. Apply the [DataContract(IsReference = true)] attribute to the entities.
• C. Apply the [Serializable] attribute to the entities.
• D. Apply the virtual keyword to the entity properties.

You have a ContosoEntities context object named context and a Color object stored in a variable named color.
You write the following code:
context.Colors.DeleteObject(color); context.SaveChanges();
When the code runs, it generates the following exception:
System.Data.UpdateException: An error occurred while updating the entries. See
the inner exception for detials. --->
System.Data.SqlClient.SqlException: The DELETE satement conflicted with the
REFERENCE constraint "FK_PartColor".
The conflict occurred in database "Contoso", table "dbo.Parts", column
'ColorId'
You need to resolve the exception without negatively impacting the rest of the application. What should you do?

• A. Add code before the call to the DeleteObject() method to examine the collection of Part objects associated with the Color object and then assign null to the Color property for each Part object.
• B. Change the End2 OnDelete proprety of the FK_PartColor association from None to Cascade
• C. Add a transation around the call to the SaveChanges() method and handle the exception by performing a retry.
• D. Change the End1 OnDelete proprety of the FK_PartColor association from None to Cascade
• E. In the database, remove the foreign key association between the Parts table and the Colors table, and then update the entity data model.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The conceptual schema definition language (CSDL) file contains the following XML fragment.
<EntityType Name="Contact"> ... <Property Name="EmailPhoneComplexProperty"
Type="AdventureWorksModel.EmailPhone" Nullable="false" />
</EntityType>
...
<ComplexType Name="EmailPhone">
<Property Type="String" Name="EmailAddress" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Type="String" Name="Phone" MaxLength="25" FixedLength="false" Unicode="true" /> </ComplexType>
You write the following code segment. (Line numbers are included for reference only.)
01 using (EntityConnection conn = new EntityConnection("name=AdvWksEntities"))
02 {
03 conn.Open();
04 string esqlQuery = @"SELECT VALUE contacts FROM
05 AdvWksEntities.Contacts AS contacts
06 WHERE contacts.ContactID == 3";
07 using (EntityCommand cmd = conn.CreateCommand())
08 {
09 cmd.CommandText = esqlQuery;
10 using (EntityDataReader rdr = cmd.ExecuteReader())
11 {
12 while (rdr.Read())
13
{
14
...
15
}
16
}
17
}
18 conn.Close(); 19 }
You need to ensure that the code returns a reference to a ComplexType entity in the model named
EmailPhone.
Which code segment should you insert at line 14?

• A. int fieldCount = rdr["EmailPhone"].DataRecordInfo.FieldMetadata.Count; for (int FldIdx = 0; FldIdx < fieldCount; FldIdx++) {
  rdr.GetName(FldIdx);
  if (rdr.IsDBNull(FldIdx) == false)
  {
  return rdr["EmailPhone"].GetValue(FldIdx).ToString();
  }
  }
• B. int FldIdx = 0; EntityKey key = record.GetValue(FldIdx) as EntityKey; foreach (EntityKeyMember keyMember in key.EntityKeyValues)
  {
  return keyMember.Key + " : " + keyMember.Value;
  }
• C. IExtendedDataRecord record = rdr["EmailPhone"]as IExtendedDataRecord; int FldIdx = 0; return record.GetValue(FldIdx);
• D. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord; return nestedRecord;

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 must retrieve a connection string.
Which of the following is the correct connection string?

• A. string connectionString = ApplicationManager.ConnectionStrings["connectionString"];
• B. string connectionString = ConfigurationSettings.AppSettings["connectionString"];
• C. string connectionString = ConfigurationManager.ConnectionStrings ["connectionString"].ConnectionString;
• D. string connectionString = ConfigurationManager.AppSettings["connectionString"];

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. The application uses DataContexts to
query the database.
You create a function that meets the following requirements:
-Updates the Customer table on the database when a customer is marked as deleted.
-Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted.
-Prevents consumer code from setting the Deleted column's value directly.
You need to ensure that the function verifies that customers have no outstanding orders before they are
marked as deleted.
You also need to ensure that existing applications can use the update function without requiring changes in
the code.
What should you do?

• A. Add new entities to the DataContext object for the Customers and Orders tables.
• B. Override the Update operation of the DataContext object.
• C. Override the Delete operation of the DataContext object.
• D. Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.