How to do Count(), Group with QueryExpression/ObservableCollection Result with ASP.NET?

Question

In the original version of this ASP.NET program which is for processing data from Dynamics CRM 365, the QueryExpression Result is transferred to ObservableCollection, then final result in xml format. Now I need to add some count() and group by to the QueryExpression or ObservableCollection.

How can I do it? May be with LINQ?

If possible please create an [mcve] – Marco May 14 '18 at 09:23 — Marco, May 14 '18 at 09:23

AliJP · Answer 1 · 2018-05-14T09:53:07.563

0

Yes, ObservableCollection is drived from Collection and Collection implements IEnumerable so you can use linq on it.
Here is an example of using Enumerable.Count() and group by on an ObservableCollection:

var li = new Dictionary<int, string> { [1] = "1", [2] = "2", [3] = "3" };
var observCollection = new ObservableCollection<KeyValuePair<int, string>>(li);
var t = (from p in observCollection
         group p by p.Key into grp
         select grp.Count());

edited May 14 '18 at 09:53

answered May 14 '18 at 09:20

AliJP

668
1
4
16

Thanks, but can I use count(), group by with this? – autopenta May 14 '18 at 09:32
Yes, of course, it implements IEnumerable so you can use all linq method on it. – AliJP May 14 '18 at 09:41

How to do Count(), Group with QueryExpression/ObservableCollection Result with ASP.NET?

1 Answers1