The user interface requires that a paged view be displayed of all the products sorted in alphabetical order.
The user interface supplies a current starting index and a page size in variables named startIndex and
pageSize of type int.
You need to construct a LINQ expression that will return the appropriate Parts from the database from an
existing
ContosoEntities context object named context. You begin by writing the following expression:
context.Parts
Which query parts should you use in sequence to complete the expression?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in
the correct order.)

• A. .OrderBy(x => x.Name)
• B. .Take(startIndex)
• C. .Skip(pageSize)
• D. .Skip(startIndex)
• E. .Take(pageSize);

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Data Model for the fallowing database tables.

You need to ensure that the entity that is mapped to the ContectTypeDerived table derives from the entity that is mapped to the ContentTypeBase table. What should you do?

• A. Use a Table-Per-Hierarchy mapping method.
• B. Create a complect type for each entity.
• C. Use a Table-Per-Type mapping method.
• D. Create a function import for each entity.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a stored procedure to insert a new record in the Categories table according to following code
segment.
CREATE PROCEDURE dbo.InsertCategory @CategoryName navrchar(15),
@Identity int OUT
AS INSERT INTO Categories(CategoryName) VALUES (@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You add the following code fragment. (Line numbers are included for reference only.)
01 private static void ReturnIdentity(string connectionString)
02 {
03 using(SqlConnection connection = new SqlConnection(connectionString))
04 {
05 SqlDataAdpater adapter = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM dbo.Categories", connection);
06 adapter.InsertCommand = new SqlCommand("InsertCategory", connection);
07 adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
08 SqlParameter rowcountParameter = adapter.InsertCommand.Parameters.Add
("@RowCount", SqlDbType.Int);
09 ...
10 adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.NChar,
15, "CategoryName");
11 SqlParameter identityParameter = adapter.InsertCommand.Parameters.Add
("@Identity", SqlDbType.Int, 0, "CategoryID");
12 ...
13 DataTable categories = new DataTable();
14 adapter.Fill(categories);
15 DataRow ctegoryRow = categories.NewRow();
16 categoryRow["CategoryName"] = "New beverages";
17 categories.Rows.Add(categoryRow);
18 adapter.Update(categories);
19 Int32 rowCount = (Int32)adapter.InsertCommand.Parameters
["@RowCount"].Value;
20 }
21 }
Which code elements needs to be added in the empty lines?

• A. Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.Output;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.ReturnValue;
• B. Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.ReturnValue;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.Output;
• C. Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.ReturnValue;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.ReturnValue;
• D. Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.Output;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.Output;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the ADO.NET Entity Framework to model entities. You create an entity model as shown in the following diagram.

You need to ensure that all Person entities and their associated EmailAddresses are loaded. Which code segment should you use?

• A. var people = context.People.Except(new ObjectQuery<Person>("EmailAddresses", context)).ToList();
• B. var people = context.People.Include("Person.EmailAddresses").ToList();
• C. var people = context.People.Include("EmailAddresses").ToList();
• D. var people = context.People.Except(new ObjectQuery<Person>("Person.EmailAddresses", context)).ToList();

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
model entities.
You need to add a new type to your model that organizes scalar values within an entity.
You also need to map stored procedures for managing instances of the type. What should you do?

• A. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Derive an entity class from the existing entity as a complex type.
  3.Map the stored procedure in the MSL file with a ModificationFunctionElement.
• B. 1. Use the edmx designer to import the stored procedures.
  2.Derive an entity class from the existing entity as a complex type.
  3.Map the stored procedure in the MSL file with an AssociationEnd element.
• C. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Define a complex type in the CSDL file.
  3.Map the stored procedure in the MSL file with an AssociationEnd element.
• D. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Define a complex type in the CSDL file.
  3.Map the stored procedure in the MSL file with a ModificationFunctionElement.