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. OverwriteChanges
• B. PreserveChanges
• C. NoTracking
• D. AppendOnly

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
The application contains the following model.

Each region contains a single vendor. Customers order parts from the vendor that is located in their region.
You need to ensure that each row in the Customer table references the appropriate row from the Vendor
table.
Which code segment should you use?

• A. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.VendorlD equals c.VendorID
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.Region = u.Vendor.Region;
  }
  dc.SubmitChanges();
• B. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.Region equals c.Region
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.VendorlD = u.Vendor.VendorlD;
  }
  dc.SubmitChanges();
• C. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.VendorlD equals v.VendorID
  select new { Customer = c, Vendor = v };
  foreach (var u in query){
  u.Vendor.Region = u.Customer.Region;
  }
  dc.SubmitChanges();
• D. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.Region equals v.Region
  select new { Customer = c. Vendor = v };
  foreach (var u in query){
  u.Vendor.VendorlD = u.Customer.VendorID;
  }
  dc.SubmitChanges();

You use Microsoft .NET Framework 4.0 to develop an application that connects to two separate Microsoft
SQL Server 2008 databases.
The Customers database stores all the customer information, and the Orders database stores all the order
information.
The application includes the following code. (Line numbers are included for reference only.)
01 try
02 {
03 conn.Open();
04 tran = conn.BeginTransaction("Order");
05 SqlCommand cmd = new SqlCommand();
06 cmd.Connection = conn;
07 cmd.Transaction = tran;
08 tran.Save("save1");
09 cmd.CommandText = "INSERT INTO [Cust].dbo.Customer " + "(Name,
PhoneNumber) VALUES ('Paul Jones', " + "'404-555-1212')";
10 cmd.ExecuteNonQuery();
11 tran.Save("save2");
12 cmd.CommandText = "INSERT INTO [Orders].dbo.Order " + "(CustomerID)
VALUES (1234)";
13 cmd.ExecuteNonQuery();
14 tran.Save("save3");
15 cmd.CommandText = "INSERT INTO [Orders].dbo." + "OrderDetail (OrderlD,
ProductNumber) VALUES" + "(5678, 'DC-6721')";
16 cmd.ExecuteNonQuery();
17 tran.Commit();
18 }
19 catch (Exception ex)
20 {
21 ...
22 }
You run the program, and a timeout expired error occurs at line 16. You need to ensure that the customer
information is saved in the database.
If an error occurs while the order is being saved, you must roll back all of the order information and save the
customer information.
Which line of code should you insert at line 21?

• A. tran.Rollback("save2"); tran.Commit();
• B. tran.Rollback("save2");
• C. tran.Rollback();
• D. tran.Rollback(); tran.Commit();

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 retrieve an entity from an object context.
A different application updates the database. You need to update the entity instance to reflect updated
values in the database.
Which line of code should you use?

• A. context.Refresh(RefreshMode.StoreWins, entity);
• B. context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);
• C. context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);
• D. context.AcceptAllChanges();