070-516 試験問題を無料オンラインアクセス

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 two
ObjectContext instances named context1 and context2.
You need to persist the changes in both object contexts within a single transaction. Which code segment
should you use?

• A.using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew)) {
  context1.SaveChanges();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  }
  }
• B.using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  }
• C.using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  scope.Complete();
  }
• D.using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew))
  {
  context1.SaveChanges();
  scope1.Complete();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  scope2.Complete();
  }
  scope.Complete();
  }

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 customer and related order records.
You add a new order for an existing customer. You need to associate the Order entity with the Customer
entity.
What should you do?

• A.Use the Attach method of the ObjectContext to add both Order and Customer entities.
• B.Call the Add method on the EntityCollection of the Order entity.
• C.Use the AddObject method of the ObjectContext to add both Order and Customer entities.
• D.Set the Value property of the EntityReference of the Order entity.

The database contains orphaned Color records that are no longer connected to Part records.
You need to clean up the orphaned records. You have an existing ContosoEntities context object named
context.
Which code segment should you use?

• A.context.Colors.ToList().RemoveAll(c => !c.Parts.Any()); context.SaveChanges();
• B.var unusedColors = context.Colors.Where(c => !c.Parts.Any()); context.DeleteObject(unusedColors); context.SaveChanges();
• C.var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){
  context.DeleteObject(unused)
  }
  context.SaveChanges();
• D.context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges();

The Entity Data Model file (.edmx file) must be updated to support inheritance mapping for Products and Componets.
You need to add the following code to the \Model\Model.edmx file:
-the code in line EX243 that maps the Product type
-the code in line EX250 that maps the Component type
What should you do?

• A.Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="true" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="false" />
• B.Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="false" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="false" />
• C.Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="true" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="true" />
• D.Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="false" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="true" />

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
Entity types in the model are generated by the Entity Data Model generator tool (EdmGen.exe).
You write the following code. (Line numbers are included for reference only.)
01 MemoryStream stream = new MemoryStream();
02 var query = context.Contacts.Include("SalesOrderHeaders.SalesOrderDetails");
03 var contact = query.Where("it.LastName = @lastname", new ObjectParameter
("lastname", lastName)).First();
04 ....
You need to serialize the contact and all of its related objects to the MemoryStream so that the contact can
be deserialized back into the model.
Which code segment should you insert at line 04?

• A.var formatter = new XmlSerializer(typeof(Contact), new Type[] { typeof(SalesOrderHeader), typeof(SalesOrderDetail)
  });
  formatter.Serialize(stream, contact);
• B.var formatter = new SoapFormatter(); formatter.Serialize(stream, contact);
• C.var formatter = new BinaryFormatter(); formatter.Serialize(stream, contact);
• D.var formatter = new XmlSerializer(typeof(Contact)); formatter.Serialize(stream, contact);