Entity Framework Like 和多条件查询

 

Entity Framework 中 Like 查询可以使用 Contains 来实现，用字段.Contains(查询条件)。

    var courseInfoList = productEntities.Product_Course.Where(info => !info.IsDeleted && info.SchoolId == schoolId).OrderBy(info => info.SortIndex);
    if (!string.IsNullOrEmpty(filter))
    {
        courseInfoList = courseInfoList.Where(info => info.Name.Contains(filter)).OrderBy(info => info.SortIndex);
    }
    if (!string.IsNullOrEmpty(parentCode))
    {
        courseInfoList = courseInfoList.Where(info => info.CategoryCode == parentCode).OrderBy(info => info.SortIndex);
    }
    if (isIntroduction != "-111")
    {
        bool isIntro = bool.Parse(isIntroduction);
        courseInfoList = courseInfoList
            .Where(info => info.IsIntroduction == isIntro).OrderBy(info => info.SortIndex);
    }