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?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities. You retrieve an entity from an
object context. A different application updates the database. You need to update the entity instance
to reflect updated values in the database. Which line of code should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that connects to a Microsoft SQL Server 2008 database. You use the ADO.NET Entity Framework
Designer to model entities. You add the following stored procedure to the database, and you add a
function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment]
@Name nvarchar(50),
@ ID int NULL OUTPUT
AS
INSERT INTO Department (Name) VALUES (@Name)
SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you
use?

You use Microsoft .NET Framework 4 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?