这样的存储过程,在VS2008的LINQ TO SQL类中怎么用

[exehunter]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SEL_contractdetail]
	-- Add the parameters for the stored procedure here
@start_date datetime,
@end_date datetime,
AS
declare @orderby nvarchar(255)
declare @cmd varchar(8000) --存放整个SQL查询语句,以便动态增加WHERE ORDER BY等子句
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
set @cmd='SELECT name,sign_date,id from table1
SET @cmd=@cmd+' where sign_date between '''+convert(char(10),@start_date,120)+''' and '''+convert(char(10),@end_date,120)+''''  
exec(@cmd)
END

以上存储过程,通用情况下,在添加到LINQ TO SQL 类之后,程序中取得该类的name,sign_date等字段的内容是不能实现的,请高手解答,这样的存储过程在LINQ TO SQL类中怎么用?

[twtqing]

帮顶

[downmoon]

http://msdn.microsoft.com/zh-cn/library/bb386946.aspx

[yang_kun]

学习....................