MVC C＃选择Where(MVC C# Select Where)

MVC C＃选择Where(MVC C# Select Where)

我正在尝试按ID添加过滤器以进行以下操作：

public ActionResult Index() { var model = from o in new MainDBContext().OffLinePayments select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); }

我想做的是以下内容：

public ActionResult Index(long? id) { if (id != null) { var model = from o in new MainDBContext().OffLinePayments **Where Assigned_ID == id** select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); } else { var model = from o in new MainDBContext().OffLinePayments select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); } }

I am trying to add filter by ID for the following:

public ActionResult Index() { var model = from o in new MainDBContext().OffLinePayments select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); }

What I would like to do is the following:

public ActionResult Index(long? id) { if (id != null) { var model = from o in new MainDBContext().OffLinePayments **Where Assigned_ID == id** select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); } else { var model = from o in new MainDBContext().OffLinePayments select new EditOffLinePayment { ID = o.ID, Amount = o.Amount }; return View(model); } }

最满意答案

尝试

var model = from o in new MainDBContext().OffLinePayments where o.Assigned_ID == id select new EditOffLinePayment { ID = o.ID, Amount = o.Amount };

try

var model = from o in new MainDBContext().OffLinePayments where o.Assigned_ID == id select new EditOffLinePayment { ID = o.ID, Amount = o.Amount };