sql-server-2008 – 怎样将值从动态SQL存储进程返回到实体框架？

我有一个存储进程,它执行一些动态SQL.我想在实体框架4中行使此存储进程,可是当我实行建设伟大范例时,进程不返回任何列.有什么步伐可以逼迫它返回我的值并让实体框架吸取它们吗？这是我想要做的简化示例：

CREATE PROCEDURE sp_calculatesalary(@EmployeeId as int)
begin
    declare dynsql as varachar(500)
    @dynsql='Select @Salary=Salary,@UserName=Username from employee
            where EmployeeId='+cast(@EmployeeId as varchar)+ ''
    exec(@dynsql)
    select @Salary,@UserName
end

但这不起浸染.请帮帮我.根基上,我想行使存储进程来执动作态SQL并将值返回到实体框架.

办理要领

CREATE PROCEDURE sp_calculatesalary(@EmployeeId as int)  
as 
begin   
    declare @dynsql varchar(500)   
    declare @params nvarchar(500)
    declare @salary money
    declare @username varchar(50)
    set @dynsql='Select @sal=Salary,@usernm=Username from employee where EmployeeId=@empID'   
    set @params='@empID int,@sal money OUTPUT,@usernm varchar(50) OUTPUT'
    exec sp_executesql @dynsql,@params,@empID=@EmployeeID,@sal=@salary OUTPUT,@usernm = @username OUTPUT
    SELECT @salary,@username
end

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!