561) Exam ple 2

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 procedute to return the active products, and you must ensure that the LINQ to SQL context can track changes to these entities.

What should you do?

Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx