Jun 07, 2010 09:23 AM|sjnaughton|LINK
OK Rosalind, your problem here is that there is no way to use a stored procedure SPROC to Select data with Linq to SQL [:(]
You cam map a SPROC or Table Valued Function to a method and call that but that will not help with Dynamic Data easily see
LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures).
I would create a Custom page and manually setup the LinqDataSource probably using the OnSelecting event. If you are using Visual Studio 2010 and .Net 4 the you could use the Domain Service and this would allow you to call your SPROC instead of the normal
Linq methods, as there seems to be no way of mapping the LinqDataSource to a SPROC or Table Valued Function.