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. You write the following code. (Line numbers are included for
reference only.)
01 static void Insert()
02 {
03 NorthwindDataContext dc = new NorthwindDataContext();
04 Customer newCustomer = new Customer();
05 newCustomer.Firstname = "Todd";
06 newCustomer.Lastname = "Meadows";
07 newCustomer.Email = "[email protected]";
08 .....
09 dc.SubmitChanges();
10 }

A product named Bike Tire exists in the Products table. The new customer orders the Bike Tire product.
You need to ensure that the correct product is added to the order and that the order is associated with the
new customer.
Which code segment should you insert at line 08?

• A. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order(); newOrder.Product = newProduct;
• B. Order newOrder = new Order();
  newOrder.Product = (from p in dc.Products
  where p.ProductName == "Bike Tire"
  select p).First();
  newCustomer.Orders.Add(newOrder) ;
• C. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order (); newOrder.Product = newProduct; newCustomer.Orders.Add(newOrder) ;
• D. Order newOrder = new Order();
  newOrder.Product = (from p in dc.Products
  where p.ProductName == "Bike Tire"
  select p) .First();

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. You use the ADO.NET LINQ to Entity model
to retrieve data from the database.
You need to call a function that is defined in the conceptual model from within the LINQ to Entities queries.
You create a common language runtime (CLR) method that maps to the function. What should you do
next?

• A. Declare the method as static.
• B. Declare the method as abstract.
• C. Apply the EdmFunctionAttribute attribute to the method.
• D. Apply the EdmComplexTypeAttribute attribute to the method.

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)); formatter.Serialize(stream, contact);
• B. var formatter = new XmlSerializer(typeof(Contact), new Type[] { typeof(SalesOrderHeader), typeof(SalesOrderDetail)
  });
  formatter.Serialize(stream, contact);
• C. var formatter = new SoapFormatter(); formatter.Serialize(stream, contact);
• D. var formatter = new BinaryFormatter(); formatter.Serialize(stream, contact);

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 add the following store procedure
to the database.
CREATE PROCEDURE GetSalesPeople AS BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone FROM SalesPeople END
You write the following code segment. (Line numbers are included for reference only.)
01 SqlConnection connection = new SqlConnection("...");
02 SqlCommand command = new SqlCommand("GetSalesPeople", connection);
03 command.CommandType = CommandType.StoredProcedure;
04 ...
You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

• A. var res = command.ExecuteXmlReader();
• B. var res = command.ExecuteNonQuery();
• C. var res = command.ExecuteReader();
• D. var res = command.ExecuteScalar();

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
The application includes a table adapter named taStore, which has the following DataTable.

There is a row in the database that has a ProductID of 680. You need to change the Name column in the
row to "New Product Name".
Which code segment should you use?

• A. var dt = new taStore.ProductDataTable(); var ta = new taStoreTableAdapters.ProductTableAdapter(); ta.Fill(dt); taStore.ProductRow row = (taStore.ProductRow)dt.Rows.Find(680) ; row.Name = "New Product Name"; ta.Update(row);
• B. var ta = new taStoreTableAdapters.ProductTableAdapter(); var dt = ta.GetData(); var row = dt.Select("680") ; row[0]["Name"] = "New Product Name"; ta.Update(row);
• C. var dt = new taStore.ProductDataTable(); var ta = new taStoreTableAdapters.ProductTableAdapter(); ta.Fill(dt); var dv = new DataView(); dv.RowFilter = "680"; dv[0]["Name"] = "New Product Name"; ta.Update(dt);
• D. var dt = new taStore.ProductDataTable(); var row = dt.NewProductRow(); row.ProductID = 680; row.Name = "New Product Name"; dt.Rows.Add(row) ;