Try Microsoft : 70-516 practice torrent pass for sure

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

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 allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
-Changes made to the local data store in disconnected mode are preserved.
-Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data. What should you do?

• A. Call the query's Execute method by using the MergeOptions.OverwriteChanges option.
• B. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.
• C. Call the query's Execute method by using the MergeOptions.AppendOnly option.
• D. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

Which one of these samples it the correct way to close the connection using Command Behavior?

• A. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); conn.Close(); Console.WriteLine("{0}", rdr);
• B. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Console.WriteLine("{0}", rdr);
• C. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); rdr.Close(); Console.WriteLine("{0}", rdr);
• D. using (SqlDataReader rdr = new SqlDataReader())
  {
  string sql = @"sql statement";
  SqlConnection conn = connection.GetConnection();
  SqlCommand cmd = new SqlCommand(sql, conn);
  SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  Console.WriteLine("{0}", rdr);
  }

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. You must retrieve a connection string.
Which of the following is the correct connection string?

• A. string connectionString = ApplicationManager.ConnectionStrings["connectionString"];
• B. string connectionString = ConfigurationManager.AppSettings["connectionString"];
• C. string connectionString = ConfigurationManager.ConnectionStrings ["connectionString"].ConnectionString;
• D. string connectionString = ConfigurationSettings.AppSettings["connectionString"];

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.
You use the ADO.NET Entity Framework to model your entities. You use ADO.NET self-tracking entities.
You need to ensure that the change-tracking information for the self-tracking entities can be used to update
the database.
Which ObjectContext method should you call after changes are made to the entities?

• A. Attach
• B. Refresh
• C. ApplyChanges
• D. SaveChanges