How to split array to many arrays where id same linq

Question

I have array:

OrderProduct[] OrderProductsOrder = new OrderProduct[] { 
new OrderProduct { OrderID = 1, ProductID = 2, OrderCustomerID = 1 }, 
new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 1 }, 
new OrderProduct { OrderID = 1, ProductID = 3, OrderCustomerID = 1 }, 
new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 2 }, 
new OrderProduct { OrderID = 1, ProductID = 2, OrderCustomerID = 3 }, 
new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 3 }};

How to split this array to three arrays, order by CustomerID, using linq. Result should be this three arrays:

OrderProduct[] Customer1Order = new OrderProduct[] { 
new OrderProduct { OrderID = 1, ProductID = 2, OrderCustomerID = 1 }, 
new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 1 }, 
new OrderProduct { OrderID = 1, ProductID = 3, OrderCustomerID = 1 }};

OrderProduct[] Customer2Order = new OrderProduct[] 
{new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 2 }};

OrderProduct[] Customer3Order = new OrderProduct[] {  
new OrderProduct { OrderID = 1, ProductID = 2, OrderCustomerID = 3 }, 
new OrderProduct { OrderID = 2, ProductID = 1, OrderCustomerID = 3 }};

do you consider using GroupBy(x => x.OrderCustomerID) ?

Vladimir
– Vladimir

2016-09-21 08:44:23 +00:00
Commented Sep 21, 2016 at 8:44 — Vladimir
– Vladimir, Commented Sep 21, 2016 at 8:44

Keyur PATEL · Accepted Answer · 2016-09-21 09:02:11Z

1

Edited, removed the GroupBy() suggestion as it was redundant (courtesy of Innat3)

No reason to use GroupBy() at all, just use Where.

OrderProduct[] Customer1Order = OrderProductsOrder.Where(o => o.OrderCustomerID == 1).ToArray();

OrderProduct[] Customer2Order = OrderProductsOrder.Where(o => o.OrderCustomerID == 2).ToArray();

OrderProduct[] Customer3Order = OrderProductsOrder.Where(o => o.OrderCustomerID == 3).ToArray();

edited Sep 21, 2016 at 9:02

answered Sep 21, 2016 at 8:47

Keyur PATEL

2,3271 gold badge18 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Innat3 Over a year ago

Your code is invalid, there is no need for a GroupBy if you are going to filter them with a .Where condition, use: OrderProduct[] Customer1Order = OrderProductsOrder.Where(o => o.OrderCustomerID == 1).ToArray();

Keyur PATEL Over a year ago

In my zombie mindset, I completely missed that. You're right.

Innat3 Over a year ago

Might want to Replace o.Key with o.OrderCustomerID though, to avoid confusion

Sergey Kalinichenko · Accepted Answer · 2016-09-21 08:48:39Z

1

Start by grouping the entries by OrderCustomerID, and constructing an array from each group. After that, add groups to a dictionary:

var byCustId = OrderProductsOrder
    .GroupBy(p => p.OrderCustomerID)
    .ToDictionary(g => g.Key, g => g.ToArray());

Now you can grab individual arrays with TryGetValue or operator []:

OrderProduct[] customer2Order;
if (byCustId.TryGetValue(2, out customer2Order) {
    ... // Use customer2Order array
}

answered Sep 21, 2016 at 8:48

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

Collectives™ on Stack Overflow

How to split array to many arrays where id same linq

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related