LINQ Contains Case Insensitive

Question

This code is case sensitive, how to make it case insensitive?

public IQueryable<FACILITY_ITEM> GetFacilityItemRootByDescription(string description)
{
    return this.ObjectContext.FACILITY_ITEM.Where(fi => fi.DESCRIPTION.Contains(description));
}

Answer 1

fi => fi.DESCRIPTION.toLower().Contains(description.ToLower())

Answer 2

Use extension method Contains from System.Linq, which has Comparer:

public IQueryable<FACILITY_ITEM> GetFacilityItemRootByDescription(string description)
{
    return this.ObjectContext.FACILITY_ITEM.Where(
        fi => fi.DESCRIPTION.Contains(
            description,
            StringComparer.OrdinalIgnoreCase));
}

Answer 3

Assuming we're working with strings here, here's another "elegant" solution using IndexOf().

public IQueryable<FACILITY_ITEM> GetFacilityItemRootByDescription(string description)
{
    return this.ObjectContext.FACILITY_ITEM.Where(fi => fi.DESCRIPTION.IndexOf(description, StringComparison.InvariantCultureIgnoreCase) != -1);
}