views:

38

answers:

0
CREATE Procedure dbo.Ssample
AS    
Select 1 as One , 2 as Two ,'3' as Three    
RETURN 2



--T-SQL way to execute
declare @a int
exec @a = dbo.Ssample
select @a

How can I retrieve the return value and the result set both in linq to sql. I would appreciate if anyone can give me the dbml markup as my designer file always get auto generated as we have agreed in our team to generate the designer.cs based on dbml markup....