Microsoft 70-516 : TS: Accessing Data with Microsoft .NET Framework 4

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 create a DataSet object in the
application.
You add two DataTable objects named App_Products and App_Categories to the DataSet.
You add the following code segment to populate the DataSet object.
(Line numbers are included for reference only.)
01 public void Fill(SqlConnection cnx, DataSet ds)
02 {
03 var cmd = cnx.CreateCommand();
04 cmd.CommandText = "SELECT * FROM dbo.Products; " + "SELECT * FROM
dbo.Categories";
05 var adapter = new SqlDataAdapter(cmd);
06 ...
07 }
You need to ensure that App_Products and App_Categories are populated from the dbo.Products and
dbo.Categories database tables.
Which code segment should you insert at line 06?

• A. adapter.Fill(ds, "Products"); adapter.Fill(ds, "Categories");
• B. adapter.Fill(ds.Tables["App_Products"]); adapter.Fill(ds.Tables["App_Categories"]);
• C. adapter.TableMappings.Add("Products", "App_Products"); adapter.TableMappings.Add("Categories", "App_Categories"); adapter.Fill(ds);
• D. adapter.TableMappings.Add("Table", "App_Products"); adapter.TableMappings.Add("Table1", "App_Categories"); adapter.Fill(ds);

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

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 a partial method named OnAttached in the partial class for the entity.
• B. Create a partial method named OnStateChanged in the partial class for the entity.
• C. Create an event handler to handle the ObjectMaterialized event.
• D. Create an event handler to handle the ObjectStateManagerChanged event.

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

You have been assigned the task of writing code that executes an Entity SQL query that returns entity type
objects that contain a property of a complex type.
(Line numbers are included for reference only.)
01 using (EntityCommand cmd = conn.CreateCommand())
02 {
03 cmd.CommandText = esqlQuery;
04 EntityParameter param = new EntityParameter();
05 param.ParameterName = "id";
06 param.Value = 3;
07 cmd.Parameters.Add(param);
08 using (EntityDataReader rdr = cmd.ExecuteReader
(CommandBehavior.SequentialAccess))
09 {
10 while (rdr.Read())
11 {
12 ...
13 Console.WriteLine("Email and Phone Info:");
14 for (int i = 0; i < nestedRecord.FieldCount; i++)
15 {
16 Console.WriteLine(" " + nestedRecord.GetName(i) + ": " +
nestedRecord.GetValue(i));
17 }
18 }
19 }
20 }
Which code segment should you insert at line 12?

• A. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord;
• B. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]
• C. DataSet nestedRecord = rdr["EmailPhoneComplexProperty"] as ComplexDataSet
• D. ComplexDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

You are adding a process to the application. The process performs the following actions:
1.Opens a ContosoEntities context object named context1.
2.Loads a Part object into a variable named part1.
3.Calls the Dispose() method on context1.
4.Updates the data in part1.
5.Updates the database by using a new ContosoEntities context object named context2.
You need to update the database with the changed data from part1. What should you do?

• A. Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyOriginalValues("Parts", part1);
• B. Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ApplyCurrentValues("Parts", part1);
• C. Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyCurrentValues("Parts", part1);
• D. Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ObjectStateManager.ChangeObjectState(part1,
  System.Data.EntitySate.Modified);

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following code segment. (Line numbers are included for reference only.)
01 class DataAccessLayer
02 {
03 private static string connString;
04 ...
05 ...
06 public static DataTable GetDataTable(string command){
07 ...
08 ...
09 }
10 }
You need to define the connection life cycle of the DataAccessLayer class.
You also need to ensure that the application uses the minimum number of connections to the database.
What should you do?

• A. Insert the following code segment at line 07:
  using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open();
  }
• B. Insert the following code segment at line 04.
  private static SqlConnection conn = new SqlConnection(connString);
  public static void Open()
  {
  conn.Open();
  }
  public static void Close()
  {
  conn.Close();
  }
• C. Replace line 01 with the following code segment.
  class DataAccessLayer : IDisposable
  Insert the following code segment to line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open()
  {
  conn.Open();
  }
  public void Dispose()
  {
  conn.Close();
  }
• D. Insert the following code segment at line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open()
  {
  conn.Open();
  }
  public void Close()
  {
  conn.Close();
  }

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).