EF操作存储过程调用

  1、执行返回数据列表型

     CREATE PROCEDURE [dbo].[SP_ManageForumGroupsPostRecycle]

@userId VARCHAR(128),  --用户ID

AS

BEGIN

SET NOCOUNT ON;

DECLARE @rowId INT 

SET @rowId=( @page - 1 ) * @pageSize;

----列表数据

SELECT 

G.Id,P.Title,G.PostId,A.NikeName,G.CreateDate,G.Note FROM GroupsPostRecycle AS G 

LEFT JOIN dbo.GroupsPost AS P ON g.PostId=p.Id

LEFT JOIN HTUser.dbo.AspNetUsers AS A ON A.Id=G.UserId

WHERE 1=1 And