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 an application.
The application connects to a Microsoft SQL Server database.
The application uses a DataTable named OrderDetailTable that has the following columns:
-ID
-OrderID
-ProductID
-Quantity
-LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn column = new DataColumn("UnitPrice", typeof(double));
02 ...
03 OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object.
You also need to ensure that UnitPrice is set to 0 when it cannot be calculated.
Which code segment should you insert at line 02?

• A. column.Expression = "LineTotal/ISNULL(Quantity, 1)";
• B. column.Expression = "if(Quantity > 0, LineTotal/Quantity, 0)";
• C. column.Expression = "LineTotal/Quantity";
• D. column.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";

The database contains a table named Categories. The Categories table has a primary key identity column
named CategoryID.
The application inserts new records by using the following stored procedure.
CREATE PROCEDURE dbo.InsertCategory @CategoryName nvarchar(15), @Identity int OUT
AS INSERT INTO Categories (CategoryName) VALUES(@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You write the following code segment.
SqlDataAdapter adapter = new SqlDataAdapter("SELECT categoryID, CategoryName
FROM dbo.Categories",connection);
adapter.InsertCommand = new SqlCommand("dbo.InsertCategory", connection);
adapter.InsertCommand.CommandType = commandType.StoredProcedure;
adapter.InsertCommand.Parameters.Add(new SqlParameter("@CategoryName",
SqlDbType.NVarChar, 15,"CategoryName"));
You need to retrieve the identity value for the newly created record. Which code segment should you add?

• A. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
• B. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;
• C. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
• D. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You manually create your own Context class named AdventureWorksDB that inherits from ObjectContext.
You need to use AdventureWorksDB to invoke a stored procedure that is defined in the data source.
Which method should you call?

• A. ExecuteStoreQuery
• B. Translate
• C. ExecuteStoreCommand
• D. ExecuteFunction