Microsoft TS: Accessing Data with Microsoft .NET Framework 4 : 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 model contains an entity type
named Product.
You need to ensure that a stored procedure will be invoked when the ObjectContext.SaveChanges method
is executed after an attached Product has changed.
What should you do in the ADO.NET Entity Framework Designer?

• A. Add a stored procedure mapping for the Product entity type.
• B. Add a new entity that has a base class of Product that is mapped to the stored procedure.
• C. Add a function import for the Product entity type.
• D. Add a complex type named Product that is mapped to the stored procedure.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered. What should you do?

• A. Call the RecoveryComplete method of the TransactionManager class.
• B. Call the EnlistDurable method of the Transaction class.
• C. Call the EnlistVolatile method of the Transaction class.
• D. Call the Reenlist method of the TransactionManager class.

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.
You need to retrieve an entity, and you must ensure that the entity is loaded in a detached state.
Which MergeOption enumeration value should you use to retrieve the entity?

• A. NoTracking
• B. AppendOnly
• C. PreserveChanges
• D. OverwriteChanges

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

• A. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequiresNew))
  { .... }
  }
  }
  }
• B. try
  {
  using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
  {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
  { .... }
  }
  }
  }
• C. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  }
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }
• D. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
  { .... }
  ......
  }
  }

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 model includes the entity
shown in the following exhibit:

You need to add a function that returns the number of years since a person was hired.
You also need to ensure that the function can be used within LINQ to Entities queries. What should you do?

• A. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  YearsSince(DateTime date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }
• B. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")] public static int YearsSince(DateTime date){ throw new NotSupportedException("Direct calls are not supported."); }
• C. Use the Entity Data Model Designer to create a complex property named YearsSinceNow that can be accessed throuqh the LINQ to Entites query at a Later time
• D. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }