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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
The application connects to a Microsoft SQL Server 2008 database named AdventureWorks by using
Windows Authentication.
Information about the required Entity Data Model (EDM) is stored in the following files:
-model.csdl
-model.ssdl
-model.msl
These files are embedded as resources in the MyCompanyData.dll file.You need to define the connection
string
that is used by the application. Which connection string should you add to the app.config file?

• A. <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
  model.csdIl res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.ssdl| res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.msl; provider=System.Data.EntityClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
  Security=True;multipleactivesuitsets=true'"
  providerName="System.Data.SqlClient"/>
• B. <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
  model.csdIl res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.ssdl| res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.msl; provider=System.Data.SqlClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
  Security=True;multipleactivesuitsets=true'"
  providerName="System.Data.EntityClient"/>
• C. <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
  model.csdIl
  res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/model.ssdIl
  res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/model.msl;
  provider=System.Data.OleDBClient;
  provider connection string='Provider=sqloledb;DataSource=localhost;Initial
  Catalog=AdventureWorks;lntegrated Security=SSPI;multipleactivesuitsets=true'"
  providerName="System.Data.EntityClient"/>
• D. <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Datamodel.csdl| res://MyCompany.Data.model.ssdl| res://MyCompany.Data.model.msl; provider=System.Data.SqlClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
  Security=SSPI;multipleactivesuitsets=true'"
  providerName="System.Data.EntityClient"/>

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 the ADO.NET Entity
Framework to model entities.
The database includes objects based on the exhibit (click the Exhibit button).
The application includes the following code segment. (Line numbers are included for reference only.)
01 using(AdventureWorksEntities context = new AdventureWorksEntities())
02 {
03 ...
04 foreach (SalesOrderHeader order in customer.SalesOrderHeader)
05 {
06 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
07 foreach (SalesOrderDetail item in order.SalesOrderDetail)
08 {
09 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
10 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
11 }
12 }
13 }
You want to list all the orders for a specific customer. You need to ensure that the list contains following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert in line 03?

• A. Contact customer = (from contact in context.Contact.Include
  ("SalesOrderHeader.SalesOrderDetail")
  select contact).FirstOrDefault();
• B. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First();
• C. Contact customer = (from contact in context.Contact.Include
  ("SalesOrderHeader")
  select contact).FirstOrDefault();
• D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("@customerId", customerId)).First();

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server
2008 database.
The database contains a ClassStudent table that contains the StudentID for students who are enrolled in
the classes.
You add the following stored procedure to the database.
CREATE PROCEDURE [dbo].[GetNumEnrolled] @ClassID INT, @NumEnrolled INT OUTPUT
AS BEGIN SET NOCOUNT ON SELECT @NumEnrolled = COUNT(StudentID)
FROM ClassStudent
WHERE (ClassID = @ClassID)
END
You write the following code. (Line numbers are included for reference only.)
01 private int GetNumberEnrolled(string classID)
02 {
03 using (SqlConnection conn = new SqlConnection(GetConnectionString())
04 {
05 SqlCommand cmd = new SqlCommand("GetNumEnrolled", conn);
06 cmd.CommandType = CommandType.StoredProcedure;
07 SqlParameter parClass = cmd.Parameters.Add("@ClassID", SqlDbType.Int,
4, "classID");
08 SqlParameter parNum = cmd.Parameters.Add("@NumEnrolled",
SqlDbType.Int);
09 ...
10 conn.Open()
11 ...
12 }
13 }
You need to ensure that the GetNumberEnrolled method returns the number of students who are enrolled
for a specific class.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Insert the following code at line 09.
  parNum.Direction = ParameterDirection.Output;
• B. Insert the following code at line 11.
  int numEnrolled = 0;
  SqlDataReader reader = cmd.ExecuteReader();
  while(reader.Read())
  {
  numEnrolled = numEnrolled + (int)cmd.Parameters["@NumEnrolled"].Value; } return numEnrolled;
• C. Insert the following code at line 11.
  cmd.ExecuteNonQuery();
  return (int)parNum.Value;
• D. Insert the following code at line 09.
  parNum.Direction = ParameterDirection.Input;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application that
connects to a database by using the Entity Framework.
You create an Entity Data Model (EDM) by using the Generate from database wizard for the following
tables.

You need to ensure that the EDM contains an entity type named Employee that contains all of the data from
both tables.
What should you do?

• A. Create an inheritance relationship between the Employee and EmployeeAccess entities, and use CanAccessBuildings as an inheritance condition.
• B. Delete the EmployeeAccess entity, create a new property named CanAccessBuildings on the Employee entity, and add a mapping for the new property.
• C. Modify the .edmx file to include the following line of code. <NavigationProperty Name="Type" FromRole="EmployeeAccess" ToRole="Employee" />
• D. Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.

Which code segment will properly return the TimeSpan returned by the stopWatch variable?

• A. Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); DoSomething(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• B. Stopwatch stopWatch = new Stopwatch(); stopWatch.Begin(); DoSomething(); stopWatch.End(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• C. Stopwatch stopWatch = new Stopwatch();
  stopWatch.Start();
  DoSomething();
  stopWatch.Stop();
  TimeSpan ts = stopWatch.Elapsed;
  string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds,
  ts.Milliseconds / 10);
  Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• D. Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); DoSomething(); stopWatch.Reset(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }