在控制器中使用ViewBag和SelectList在WHERE子句中添加AND (ASP.Net MVC)

public ActionResult Index()
{
    ViewBag.Message = "Hello, World!";
    return View();
}

<h1>@ViewBag.Message</h1>

public ActionResult Index()
{
    var items = new List<SelectListItem>
    {
        new SelectListItem { Text = "Option 1", Value = "1" },
        new SelectListItem { Text = "Option 2", Value = "2" },
        new SelectListItem { Text = "Option 3", Value = "3" }
    };

    ViewBag.Options = new SelectList(items, "Value", "Text");
    return View();
}

@Html.DropDownListFor(m => m.SelectedOption, ViewBag.Options as SelectList)

public ActionResult Index()
{
    var query = from item in db.Items
                where item.Category == "Electronics" && item.Price > 100
                select item;

    return View(query.ToList());
}