You use microsoft visual studio 2010 and microsoft .net framework 4 to create an application that
connects to a database by using the entity framework. you create an entity data model (edm) by
using the generate from database wizard for the following tables.

You need to ensure that the edm contains an entity type named employee that contains all of the
data from both tables. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that uses LINQ to SQL. The application contains the following model.

Each region contains a single vendor. Customers order parts from the vendor that is located in their
region. You need to ensure that each row in the Customer table references the appropriate row
from the Vendor table. Which code segment should you use?

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. The application uses nested transaction scopes. An inner transaction scope
contains code that inserts records into the database. You need to ensure that the inner transaction
can successfully commit even if the outer transaction rolls back. What are two possible
TransoctionScope constructors that you can use for the inner transaction to achieve this goal? (Each
correct answer presents a complete solution. Choose two.)

You use Microsoft .NET Framework 4 to develop an application that uses LINQ to SQL. The LINQ to
SQL model contains the Product entity. A stored procedure named GetActiveProducts performs a
query that returns the set of active products from the database.
You need to invoke the stored procedure to return the active products, and you must ensure that
the UNQ to SQL context can track changes to these entities. What should you do?