这里我写了一个删除记录的存储过程;它在SQL中工作得很好。但是当我尝试在MVC JSON格式加载它时,它抛出了一个错误:
存储过程:实现源类型'int'的查询模式。" Select' not found"
ALTER procedure [dbo].[AccessorDataDelById]
@ID int
AS
BEGIN
DELETE FROM Accessors
WHERE Id = @ID
END
JSON格式:public JsonResult GetAssdata(int iD = 0)
{
var x = (from n in db.AccessorDataDelById(iD)
select n).FirstOrDefault();
return new JsonResult { Data = x, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
var x=db.AccessorDataDelById(iD)