You need to ensure that an exception is thrown when color names are set to less than two characters. What should you do?

• A. Add the following method to the Color partial class in Model\Color.cs:
  protected overrride void OnPropertyChanged(string property)
  {
  if (property == "Name" && this.Name.Length < 2)
  throw new ArgumentOutOfRangeException("Name must be at least two
  characters");
  }
• B. Add the following method to the Color partial class in Model\Color.cs:
  protected overrride void OnPropertyChanging(string property)
  {
  if (property == "Name" && this.Name.Length < 2)
  throw new ArgumentOutOfRangeException("Name must be at least two
  characters");
  }
• C. Add the following attribute to the Name property of the Color class in the entity designer file:
  [StringLength(256, MinimumLength = 2)]
• D. Add the following code segment to the ContosoEntities partial class in Model\ContosoEntities.cs:
  public override in SaveChanges(System.Data.Objects.SaveOptions options)
  {
  var changes = this.ObjectStateManager.GetObjectSateEntries
  (System.Data.EntityState.Added);
  foreach (var change in changes)
  {
  if (change.Entity is Color) if (((Color)change.Entity.Name.Length < 2) throw new ArgumentException ("Name too short");
  }
  return base.SaveChanges(options);
  }

You use Microsoft .NET Framework 4.0 to develop an application.
You write the following code to update data in a Microsoft SQL Server 2008 database.
(Line numbers are included for reference only.)
01 private void ExecuteUpdate(SqlCommand cmd, string connString, string
updateStmt)
02 {
03 ...
04 }
You need to ensure that the update statement executes and that the application avoids connection leaks. Which code segment should you insert at line 03?

• A. using (SqlConnection conn = new SqlConnection(connString))
  {
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery();
  cmd.Connection.Close();
  }
• B. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery();
• C. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery(); cmd.Connection.Close() ;
• D. using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open() ;
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery() ;
  }

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 Entity SQL of the ADO.NET Entity
Framework to retrieve data from the database.
You need to define a custom function in the conceptual model. You also need to ensure that the function
calculates a value based on properties of the object.
Which two XML element types should you use? (Each correct answer presents part of the solution. Choose
two.)

• A. Association
• B. FunctionImport
• C. DefiningExpression
• D. Function
• E. Dependent

Which method will return all nodes of an XDocument?

• A. doc.DescendantNodes();
• B. doc.GetAllnodes();
• C. doc.Descendants();
• D. doc.Root.Allnodes();

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 GetProducts AS BEGIN
SELECT ProductID, Name, Price, Cost FROM Product END
You create a SqlDataAdapter named adapter to execute the stored procedure. You need to fill a DataTable
instance with the first 10 rows of the result set.
What are two possible code segments that you can use to achieve the goal?

• A. DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);
• B. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);
• C. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);
• D. DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");