PetaPoco NetCore 调用带参数的存储过程

Mysql数据库存储过程

CREATE PROCEDURE `pro_statis_member`(
  startDate VARCHAR(20),
  endDate VARCHAR(20)
)
BEGIN
  /*会员每天注册量统计*/
  select 
    date(AddTime) as AddDate,
    count(1) as CountAll 
  from 
    member
  where 
    ADDTime BETWEEN startDate AND endDate
  GROUP BY date(AddTime)
  ORDER BY AddTime;
END

C#调用代码

_APIStatis是Repository对象，StatisMember是统计实体类

string startDate="2024-01-01";
string endDate="2024-11-01";
_APIStatis.DbContext.Query<StatisMember>("CALL pro_statis_member(@0, @1)", startDate, endDate).ToList<StatisMember>();