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

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 manage Plain Old CLR Objects (POCO) entities.
You create a new POCO class. You need to ensure that the class meets the following requirements:
-It can be used by an ObjectContext.
-It is enabled for change-tracking proxies.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Configure the navigation property to return a type that implements the ICollection interface.
• B. Configure the navigation property to return a type that implements the IQueryable interface.
• C. Modify each mapped property to contain non-sealed, public, and virtual accessors.
• D. Configure the navigation property to return a type that implements the IEntityWithRelationships interface.
• E. Modify each mapped property to contain sealed and protected accessors.

Explanation: Only visible for ExamsReviews members. You can sign-up / login (it's free).

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.
You define a Category class by writing the following code segment. (Line numbers are included for
reference only.)
01 public class Category
02 {
03 public int CategoryID { get; set; }
04 public string CategoryName { get; set; }
05 public string Description { get; set; }
06 public byte[] Picture { get; set; }
07 ...
08 }
You need to add a collection named Products to the Category class. You also need to ensure that the
collection supports deferred loading.
Which code segment should you insert at line 07?

• A. public static List <Product> Products { get; set; }
• B. public virtual List <Product> Products { get; set; }
• C. public abstract List <Product> Products { get; set; }
• D. protected List <Product> Products { get; set; }

Explanation: Only visible for ExamsReviews members. You can sign-up / login (it's free).

The user interface requires that a paged view be displayed of all the products sorted in alphabetical order.
The user interface supplies a current starting index and a page size in variables named startIndex and
pageSize of type int.
You need to construct a LINQ expression that will return the appropriate Parts from the database from an
existing
ContosoEntities context object named context. You begin by writing the following expression:
context.Parts
Which query parts should you use in sequence to complete the expression?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in
the correct order.)

• A. .Take(startIndex)
• B. .Skip(startIndex)
• C. .Take(pageSize);
• D. .Skip(pageSize)
• E. .OrderBy(x => x.Name)

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 [Serializable] attribute to the entities.
• B. Apply the virtual keyword to the entity properties.
• C. Apply the [DataContract(IsReference = false)] attribute to the entities.
• D. Apply the [DataContract(IsReference = true)] attribute to the entities.

Explanation: Only visible for ExamsReviews members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
The application includes self-tracking entities as shown in the following diagram.

There is a Person entity names person1 that has TrackChanges turned on.
You need to delete all e-mail addresses that are associated with person1 by using an ObjectContext.
What are two possible code segments that you can use to achieve this goal?
(Each correct answer presents a complete solution. Choose two).

• A. foreach(var email in person1.EMailAddresses){
  email.MarkAsDeleted();
  }
  context.SaveChanges();
• B. person1.EMailAddresses = null; context.SaveChanges();
• C. while(person1.EMailAddresses.Count>0){
  person1.EmailAddresses.RemoveAt(0);
  }
  context.SaveChanges();
• D. person1.EMailAddresses = new TrackableCollection<EMailAddress>(); context.SaveChanges();

Explanation: Only visible for ExamsReviews members. You can sign-up / login (it's free).