You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create an Entity Data Model (EDM) by using the Microsoft ADO.NET Entity Data Model Designer (Entity
Designer).
The EDM contains a complex type. You need to map a stored procedure to the complex type by using the
Entity Designer.
What should you do?

• A. Add an association to the stored procedure.
• B. Add an entity that mirrors the properties of the complex type.
• C. Add a code generation item that has the name of the stored procedure.
• D. Add a function import for the stored procedure.

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.
The database includes a database table named ProductCatalog as shown in the exhibit:

You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are included for reference only.)
01 using(SqlConnection cnx = new SqlConnection(connString)
02 {
03 var command = cnx.CreateCommand();
04 command.CommandType = CommandType.Text;
05 command.CommandText = "SELECT TOP 1 * FROM dbo.ProductCatalog";
06 cnx.Open();
07 var reader = command.ExecuteReader();
08 if (reader.Read())
09 {
10 var id = reader.GetInt32(0);
11 ...
12 reader.Close();
13 }
14 }
Which answer belongs in line 11?

• A. var weight
  = reader.GetFloat(1); var price = reader.GetDecimal(2); var status = reader.GetByte(3);
• B. var weight = reader.GetFloat(1); var price = reader.Doublel(2); var status = reader.GetByte(3);
• C. var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);
• D. var weight = reader.GetDouble(1); var price = reader.GetFloat(2); var status = reader.GetBoolean(3);

You use Microsoft Visual studio 2010 and Microsoft NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities. The model includes the entity
shown in the following exhibit:

You need to add a function that returns the number of years since a person was hired.
You also need to ensure that the function can be used within LINQ to Entities queries. What should you do?

• A. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }
• B. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")] public static int YearsSince(DateTime date){ throw new NotSupportedException("Direct calls are not supported."); }
• C. Use the Entity Data Model Designer to create a complex property named YearsSinceNow that can be accessed throuqh the LINQ to Entites query at a Later time
• D. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  YearsSince(DateTime date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }

How do you call a model-defined function as static method on a custom class?

• A. Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts an IQueryable argument and returns the results of the Execute method that is returned by the Provider property.
• B. Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts ICollection argument and returns the results of the Execute method that is returned by the Provider property.
• C. Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts and returns the results of the Execute method that is returned by the Provider property.
• D. Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts IEntityWithRelationships argument and returns the results of the Execute method that is returned by the Provider property.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
You want to connect the application to a Microsoft SQL Server Express 2008 database named
MyDatabase.
The primary database file is named MyDatabase.mdf and it is stored in the App_Data folder.
You need to define the connection string. Which connection string should you add to the Web.config file?

• A. Data Source=localhost; Initial Catalog=MyDataBase; Integrated Security=SSPI; User Instance=True
• B. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True
• C. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True
• D. Data Source=.\SQLEXPRESS; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True