You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model using model-first development.
The database has the following requirements:
-each table must have a datetime column named time_modified
-each table requires a trigger that updates the value of the time_modified column when a row is inserted or updated
You need to ensure that the database script that is created by using the Generate Database From Model
option meets the requirements.
What should you do?

• A. Create a new T4 template, and set the DDL Generation template to the name of the new template.
• B. Add a DateTime property named time_modified to each entity in the model and set the property's StoreGeneratedPattern to Computed.
• C. Add a new entity named time_modified to the model, and modify each existing entity so that it inherits from the new entity.
• D. Create a new Windows Workflow Foundation workflow, and set Database Generation Workflow to the name of the new workflow.

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 Entity Framework to manage persistence-ignorant entities. You create an
ObjectContext instance named context.
Then, you directly modify properties on several entities. You need to save the modified entity values to the
database.
Which code segment should you use?

• A. context.SaveChanges();
• B. context.SaveChanges(SaveOptions.AcceptAllChangesAfterSave);
• C. context.SaveChanges(SaveOptions.DetectChangesBeforeSave);
• D. context.SaveChanges(SaveOptions.None);

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.Input;
• B. Insert the following code at line 09.
  parNum.Direction = ParameterDirection.Output;
• C. Insert the following code at line 11.
  cmd.ExecuteNonQuery();
  return (int)parNum.Value;
• D. 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;

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. ExecuteStoreCommand
• C. ExecuteFunction
• D. Translate