Linq - How to exclude items from autocomplete array

Question

Hello all.

I have the following code that gives me a an array in an autocomplete extender:

return autocomplete.tblAutoCompletes
                    .Where(p => p.MemberId == memberid && p.LocationId == locationid && p.ACItem.Contains(prefixText))
                    .OrderBy(p => p.ACItem)
                    .Select(p => p.ACItem)
                    .Take(count)
                    .ToArray();

However, I may need to programmatically exclude certain items from the array.

How would I do that? So for example, ACItem list = Product1, Product2, Product3.

How would I amend the code so that Product2 is excluded?

Answer 1

autocomplete.tblAutoCompletes
                .Where(p => p.MemberId == memberid && p.LocationId == locationid && p.ACItem.Contains(prefixText))
                .OrderBy(p => p.ACItem)
                .Select(p => p.ACItem)
                .Take(count)
                .Where(p => p != Product1)
                .Select(p => p)
                .ToArray();