I'm going nuts trying to get this to work and I've distilled it down to the simplest possible example. I want to execute a stored procedure (SQL Server 2005) and return rows from a table. I've added the Linq-to-SQL classes and dragged the table and stored procedure onto the work surface. My stored procedure looks like: Code Snippet CREATE PROCEDURE GetCategories AS BEGIN SET NOCOUNT ON ; SELECT * FROM Category END GO The table looks like: Code Snippet CREATE TABLE [dbo] . [Category] ( [CategoryId]
Read More...