Linq select objects in list where exists IN (A,B,C)

c# linq list linq-to-objects exists
MartinS picture MartinS · Jan 10, 2013 · Viewed 319.8k times · Source

I have a list of orders.
I want to select orders based on a set of order statuses.

So essentially select orders where order.StatusCode in ("A", "B", "C")

// Filter the orders based on the order status
var filteredOrders = from order in orders.Order
                     where order.StatusCode.????????("A", "B", "C")
                     select order;

Answer

Tim Schmelter picture Tim Schmelter · Jan 10, 2013

Your status-codes are also a collection, so use Contains:

var allowedStatus = new[]{ "A", "B", "C" };
var filteredOrders = orders.Order.Where(o => allowedStatus.Contains(o.StatusCode));

or in query syntax:

var filteredOrders = from order in orders.Order
                     where allowedStatus.Contains(order.StatusCode)
                     select order;

Related questions

Filtering lists using LINQ

I've got a list of People that are returned from an external app and I'm creating an exclusion list in my local app to give me the option of manually removing people from the list. I have a composite key …

Read More
How do i get the difference in two lists in C#?

Ok so I have two lists in C# List<Attribute> attributes = new List<Attribute>(); List<string> songs = new List<string>(); one is of strings and and one is of a attribute object …

Read More
Select distinct using linq

I have a class list of class public class LinqTest { public int id { get; set; } public string value { get; set; } } List<LinqTest> myList = new List<LinqTest>(); myList.Add(new LinqTest() { id = 1, value = "a" }); myList.Add(new …

Read More