LIKE在"where"LINQ语句导致错误

ProductModel.cs:(上课)

public List GetSearchedProduct (string Name)
{
    try
    {
        using (garagedbEntities db = new garagedbEntities())
        {
            List products = (from x in db.Products
                                      where x.Name LIKE @txtSearch
                                      select x).ToList();
            return products;
        }
    }
    catch (Exception)
    {
        return null;
    }
}

search.aspx:

 <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master"   AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>





    
    

 



    


    

这是我的search.aspx档案.实际上我想得到的名称product从TextBox然后传递给检索的方法products.

在linq中你应该使用Contains:

List products = (from x in db.Products
                           where x.Name.Contains(Name)
                           select x).ToList();

编辑:要使用方法,您应该创建一个新实例,ProductModel然后调用该GetSearchedProduct方法并将其txtSearch作为参数发送给它.像这样:

protected void btnSearch_OnClick(object sender, EventArgs e)
{
    ProductModel pr = new ProductModel();
    var result = pr.GetSearchedProduct(txtSearch.Text);
}