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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that uses the Entity Framework.
The build configuration is set to Release. The application must be published by using Microsoft Visual Studio 2010, with the following requirements:
-The database schema must be created on the destination database server.
-The Entity Framework connection string must be updated so that it refers to the destination database server.
You need to configure the application to meet the requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Use the web.config transform file to modify the connection string for the release configuration.
• B. Generate the DDL from the Entity Framework Designer and include it in the project. Set the action for the DDL to ApplicationDefinition.
• C. Include the source database entry in the Package/Publish SQL tab and update the connection string for the destination database.
• D. Set Items to deploy in the Package/Publish Web tab to All files in this Project Folder for the release configuration.

The application user interface displays part names or color names in many plases as '## Name ##'.
You need to provide a method named FormattedName() to format part names and color names throughout
the
application. What should you do?

• A. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Part entity){
  return string.Format("## {0} ##", entity.Name)
  }
• B. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Color entity){
  return string.Format("## {0} ##", entity.Name)
  }
• C. Add the following code segmend to the Color class in Color.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• D. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this IName entity){
  return string.Format("## {0} ##", entity.Name)
  }
• E. Add the following code segmend to the Part class in Part.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }

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

Explanation: Only visible for VCETorrent 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 uses the ADO.NET Entity Framework to model entities.
You define a Category class by writing the following code segment. (Line numbers are included for
reference only.)
01 public class Category
02 {
03 public int CategoryID { get; set; }
04 public string CategoryName { get; set; }
05 public string Description { get; set; }
06 public byte[] Picture { get; set; }
07 ...
08 }
You need to add a collection named Products to the Category class. You also need to ensure that the
collection supports deferred loading.
Which code segment should you insert at line 07?

• A. public static List <Product> Products { get; set; }
• B. public virtual List <Product> Products { get; set; }
• C. public abstract List <Product> Products { get; set; }
• D. protected List <Product> Products { get; set; }

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

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; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True
• C. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True
• D. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True

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