You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
You create a data model name AdvWorksDataContext, and you add the Product table to the data model.
The Product table contains a decimal column named ListPrice and a string column named Color.
You need to update ListPrice column where the product color is Black or Red. Which code segment should
you use?

• A. AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if(product.Color == "Black, Red"){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();
• B. AdvWorksDataContext dc = new AdvWorksDataContext("...");
  var prod = from p in dc.Products
  where p.Color == "Black, Red"
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();
• C. string[] colorList = new string[] {"Black", "Red"}; AdvWorksDataContext dc = new AdvWorksDataContext(); var prod = from p in dc.Products
  where colorList.Contains(p.Color)
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();
• D. AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if((product.Color == "Black) && (product.Color == "Red")){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a multi-tier application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
The model contains entities named SalesOrderHeader and SalesOrderDetail.
For performance considerations in querying SalesOrderHeader, you detach SalesOrderDetail entities from
ObjectContext.
You need to ensure that changes made to existing SalesOrderDetail entities updated in other areas of your
application are persisted to the database.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Call ObjectContext.ApplyOriginalValue.
• B. Re-attach the SalesOrderDetail entities.
• C. Set the MergeOption of SalesOrderDetail to MergeOptions.NoTracking.
• D. Call ObjectContext.ApplyCurrentValue.
• E. Set the MergeOption of SalesOrderDetail to MergeOptions.OverwriteChanges.

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the
Entity Framewok.
You need to execute custom logic when an entity is attached to the ObjectContext. What should you do?

• A. Create an event handler to handle the ObjectStateManagerChanged event.
• B. Create an event handler to handle the ObjectMaterialized event.
• C. Create a partial method named OnAttached in the partial class for the entity.
• D. Create a partial method named OnStateChanged in the partial class for the entity.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
You plan to deploy the application to several shared client computers. You write the following code
segment.
(Line numbers are included for reference only.)
01 Configuration config = ConfigurationManager.OpenExeConfiguration
(exeConfigName);
02 ...
03 config.Save();
04 ...
You need to encrypt the connection string stored in the .config file. Which code segment should you insert at line 02?

• A. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
• B. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
• C. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
• D. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses the ADO.NET Entity
Framework to manage order data.
The application makes a Web service call to obtain orders from an order-tracking system.
You need to ensure that the orders are added to the local data store. Which method should you call on the
ObjectContext?

• A. ApplyCurrentValues
• B. AddObject
• C. Attach
• D. AttachTo