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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to two different Microsoft SQL Server 2008 database servers named Server1 and
Server2.
A string named sql1 contains a connection string to Server1. A string named sql2 contains a connection
string to Server2.
01 using (TransactionScope scope = new
02 ...
03 )
04 {
05 using (SqlConnection cn1 = new SqlConnection(sql1))
06 {
07 try{
08 ...
09 }
10 catch (Exception ex)
11 {
12 }
13 }
14 scope.Complete();
15 }
You need to ensure that the application meets the following requirements:
-There is a SqlConnection named cn2 that uses sql2.
-The commands that use cn1 are initially enlisted as a lightweight transaction.
The cn2 SqlConnection is enlisted in the same TransactionScope only if commands executed by cn1 do not
throw an exception.
What should you do?

• A. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }
• B. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }
• C. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2)) {
  try{
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }
• D. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }

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

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 create classes by using LINQ to SQL based on the records shown in the exhibit:

You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID
properties.
You need to retrieve the total price amount of each Order record. What are two possible ways to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

• A. from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Detail on g.Key equals details.OrderID
  select new
  {
  OrderID = details.OrderID,
  CustomerID = details.Order.CustomerID,
  TotalAmount = details.UnitPrice * details.Quantity
  }
• B. dataContext.Order_Detail.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID,
  (dts, ord) => new {
  OrderID = dts.OrderID,
  CustomerID = dts.Order.CustomerID,
  TotalAmount = dts.UnitPrice * dts.Quantity
  })
• C. dataContext.Orders.GroupJoin(dataContext.Order_Detail, o => o.OrderID, d => d.OrderID,
  (ord, dts) => new {
  OrderID = ord.OrderID,
  CustomerID = ord.CustomerID,
  TotalAmount = dts.Sum(od => od.UnitPrice *
  od.Quantity)
  })
• D. from details in dataContext.Order_Detail group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new {
  OrderID = order.OrderID,
  CustomerID = order.CustomerID,
  TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity)
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model using model-first development.
The database has the following requirements:
-each table must have a datetime column named time_modified
-each table requires a trigger that updates the value of the time_modified column when a row is inserted or updated
You need to ensure that the database script that is created by using the Generate Database From Model
option meets the requirements.
What should you do?

• A. Add a new entity named time_modified to the model, and modify each existing entity so that it inherits from the new entity.
• B. Create a new T4 template, and set the DDL Generation template to the name of the new template.
• C. Create a new Windows Workflow Foundation workflow, and set Database Generation Workflow to the name of the new workflow.
• D. Add a DateTime property named time_modified to each entity in the model and set the property's StoreGeneratedPattern to Computed.

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 EnlistVolatile method of the Transaction class.
• B. Call the EnlistDurable method of the Transaction class.
• C. Call the Reenlist method of the TransactionManager class.
• D. Call the RecoveryComplete method of the TransactionManager class.