Study with Microsoft : 70-516 Exam Torrent as your best preparation materials

You use Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that connects to a
Microsoft SQL Server 2008 database.
The application uses Integrated Windows authentication in Internet Information Services (IIS) to
authenticate users.
A connection string named connString defines a connection to the database by using integrated security.
You need to ensure that a SqlCommand executes under the application pool's identity on the database
server.
Which code segment should you use?

• A. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  using (HostingEnvironment.Impersonate())
  {
  conn.Open();
  }
  var result = cmd.ExecuteScalar();
  }
• B. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  SqlCommand cmd = null;
  using (HostingEnvironment.Impersonate())
  {
  cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  }
  conn.Open();
  var result = cmd.ExecuteScalar();
  }
• C. using (var conn = new SqlConnection(connString))
  {
  var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
  conn.Open();
  using(HostingEnvironment.Impersonate())
  {
  var result = cmd.ExecuteScalar();
  }
  }
• D. using (var conn = new SqlConneccion())
  {
  using (HostingEnvironroent.Impersonate())
  {
  conn.ConnectionString = connString;
  }
  var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
  conn.Open() ;
  var result = cmd.ExecuteScalar();
  }

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 manage order data.
The application makes a Web service call to obtain orders from an order-tracking system.
You need to ensure that the orders are added to the local data store. Which method should you call on the
ObjectContext?

• A. ApplyCurrentValues
• B. AddObject
• C. AttachTo
• D. Attach

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 (EDM).
You need to create a database creation script for the EDM. What should you do?

• A. Select Run Custom Tool from the solution menu.
• B. Run the Generate Database command.
• C. Drag entities to Server Explorer.
• D. Use a new Self-Tracking Entities template.

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 application includes a Customer entity along with a CustomerKey property of the Guid type as shown in
the following exhibit:

You discover that when the application adds a new instance of a Customer, calling the SaveChanges
method
results in the following error message: "Server generated keys are only supported for identity columns."
You need to ensure that the application can add new Customer entities. What should you do?

• A. Call the ObjectContext.CreateEntityKey method before saving a Customer entity.
• B. Add a handler for the ObjectContext.ObjectMaterialized event. In the event handler, set the CustomerKey value.
• C. Call the ObjectContext.Attach method before saving a Customer entity.
• D. Add a handler for the ObjectContext.SavingChanges event. In the event handler, set the CustomerKey value.

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application.
You use entity Framework Designer to create an Entity Data Model from an existing database by using the
Generate From Database wizard.
The model contains an entity type named Product. The Product type requires an additional property that is
not mapped to database colomn.
You need to add the property to product. What should you do?

• A. Add the property in the generated class file, and select Run Custom Tool from the solution menu.
• B. Create a comlex type with the name of the property in the Entity Framework Designer.
• C. Add the property in a partial class named Product in a new source file.
• D. Create a function import with the name of property in the Entity Framework Designer.