CREATE PROCEDURE [dbo].[prcTest]
    @KeyWord varchar(512)                        --关键词
AS
BEGIN

    SET NOCOUNT ON

    DECLARE
        @KeyWordID INT,
        @IDPartition INT,
        @where NVARCHAR(4000),
        --@strMonth NVARCHAR(4000),
        @SQL NVARCHAR(max)

    select @KeyWordID = ID from RDAS.dbo.D_KeyWord where [KeyWord]=@KeyWord

    SET @IDPartition=RDAS.dbo.funGetIDByKeyWordID(@KeyWordID)

    SET @SQL = 'SELECT [KeyWordID],[UserID],[UserExpense] as [Expense],[Profession]
    FROM [RDAS_Core].[dbo].[T_User_Expense_Count_'
    +right('00000'+convert(varchar(5),@IDPartition),5)+'] where [KeyWordID] = @KeyWordID
    order by [Expense] desc'

    --SELECT @SQL
    EXEC sp_executesql @SQL, N'@KeyWord varchar(512),@KeyWordID int',
    @KeyWord ,@KeyWordID--,@startyear,@startmonth,@endyear,@endmonth,@KeyWordID
END

        public virtual int prcTest(string keyWord)
        {
            var keyWordParameter = keyWord != null ?
                new ObjectParameter("KeyWord", keyWord) :
                new ObjectParameter("KeyWord", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("prcTest", keyWordParameter);
        }

修改存储过程，测试用的所以就修改成这样

CREATE PROCEDURE [dbo].[prcTestModify]
    @KeyWord varchar(512)                        --关键词
AS
BEGIN
    SELECT [KeyWordID],[UserID],[UserExpense] as [Expense],[Profession]
    FROM [RDAS_Core].[dbo].[T_User_Expense_Count_00033]
        where [KeyWordID] = @KeyWord
    order by [Expense] desc
END

GO

生成这样的代码，是我想要的结果       

 public virtual ObjectResult<prcTestModify_Result> prcTestModify(string keyWord)
        {
            var keyWordParameter = keyWord != null ?
                new ObjectParameter("KeyWord", keyWord) :
                new ObjectParameter("KeyWord", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<prcTestModify_Result>("prcTestModify", keyWordParameter);
        }