using(DAD_BaldipContext ctx = new DAD_BaldipContext())
{
int month = 02;
int year = 2018;
var x = ctx.TruckRentalPb.FromSqlRaw("TotalMonthlyRental @month, @year", month, year).ToList();
textbox.Text = x[1].TruckId.ToString();
}
存储过程:
ALTER PROCEDURE [dbo].[TotalMonthlyRental]
@month int,
@year int
AS
BEGIN
SET NOCOUNT ON;
SELECT MONTH(RentDate) AS Month, SUM(TotalPrice) AS TotalRental
FROM [TruckRental-PB]
WHERE MONTH(RentDate) = @month
AND YEAR(RentDate) = @year
GROUP BY MONTH([RentDate]), YEAR(RentDate)
END
我想调用名为 TotalMonthlyRental
的存储过程,它需要两个参数:月份和年份。
虽然我已经硬编码了一个月份和年份,但是我却收到了“必须声明标量变量 month”的错误提示。