Microsoft 70-516 Value Pack (Frequently Bought Together)

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 create a DataSet object in the
application.
You add two DataTable objects named App_Products and App_Categories to the DataSet.
You add the following code segment to populate the DataSet object.
(Line numbers are included for reference only.)
01 public void Fill(SqlConnection cnx, DataSet ds)
02 {
03 var cmd = cnx.CreateCommand();
04 cmd.CommandText = "SELECT * FROM dbo.Products; " + "SELECT * FROM
dbo.Categories";
05 var adapter = new SqlDataAdapter(cmd);
06 ...
07 }
You need to ensure that App_Products and App_Categories are populated from the dbo.Products and
dbo.Categories database tables.
Which code segment should you insert at line 06?

• A. adapter.Fill(ds.Tables["App_Products"]); adapter.Fill(ds.Tables["App_Categories"]);
• B. adapter.TableMappings.Add("Products", "App_Products"); adapter.TableMappings.Add("Categories", "App_Categories"); adapter.Fill(ds);
• C. adapter.Fill(ds, "Products"); adapter.Fill(ds, "Categories");
• D. adapter.TableMappings.Add("Table", "App_Products"); adapter.TableMappings.Add("Table1", "App_Categories"); adapter.Fill(ds);

You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4.0 application. You create an Entity Data Model for the database tables shown in the following diagram.

You need to modify the .edmx file so that a many-to-many association can exist between the Address and
Customer entities.
Which storage Model section of the .edmx file should you include?

• A. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50" />
  </EntityType>
• B. <EntityType Name="CustomerAddress"> <Key>
  <PropertyRef Name="CustomerAddressID" /> </Key> <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• C. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerAddressID" />
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• D. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false" />
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"
  DefaultValue="Home" />
  </EntityType>

You have a ContosoEntities context object named context and a Color object stored in a variable named color.
You write the following code:
context.Colors.DeleteObject(color); context.SaveChanges();
When the code runs, it generates the following exception:
System.Data.UpdateException: An error occurred while updating the entries. See
the inner exception for detials. --->
System.Data.SqlClient.SqlException: The DELETE satement conflicted with the
REFERENCE constraint "FK_PartColor".
The conflict occurred in database "Contoso", table "dbo.Parts", column
'ColorId'
You need to resolve the exception without negatively impacting the rest of the application. What should you do?

• A. Add a transation around the call to the SaveChanges() method and handle the exception by performing a retry.
• B. Change the End2 OnDelete proprety of the FK_PartColor association from None to Cascade
• C. Add code before the call to the DeleteObject() method to examine the collection of Part objects associated with the Color object and then assign null to the Color property for each Part object.
• D. In the database, remove the foreign key association between the Parts table and the Colors table, and then update the entity data model.
• E. Change the End1 OnDelete proprety of the FK_PartColor association from None to Cascade

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

You use Microsoft .NET Framework 4.0 to develop an application that uses Entity Framework. The application includes the following Entity SQL (ESQL) query.
SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice
You need to modify the query to support paging of the query results. Which query should you use?

• A. SELECT TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip
• B. SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip LIMIT @limit
• C. SELECT SKIP @skip VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice LIMIT @limit
• D. SELECT SKIP @skip TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice