LINQ group by dynamic

Asked Dec 16 '14 at 18:19

Active Dec 16 '14 at 20:44

Viewed 369 times

I am trying to make a dynamic grouping for LINQ and I am just not getting the syntax correct. Any help would be greatly appreciated. Here is my static LINQ code;

var query =
    from x in myCollection
    group x by x.Field1 into g
    select new myClass
    {
            /// <summary>
            /// Group logic removed
            /// </summary>
    };

thanks

edit:
I did see some examples but it seems I am not smart enough to figure it. Also I just realized that I never stated myCollection is an ObservableCollection This is what I have tried to make the above query into;

var group = myCollection.GroupBy(
"new(it[\"Field1\"] as Field1,it[\"Field2\"]as Field2)", "it"
)
.Select(x =>
new myClass {
    Net = x.Sum(y => y.Net),
    Field1 = x.First().Field1,
    Field2 = x.First().Field2,
} );

This returns an error of;

The type arguments for method 'System.Linq.Enumerable.GroupBy<TSource,TKey>(System.Collections.Generic.IEnumerable<TSource>, System.Func<TSource,TKey>, System.Collections.Generic.IEqualityComparer<TKey>)' cannot be inferred from the usage. Try specifying the type arguments explicitly.

edited Dec 16 '14 at 20:44

asked Dec 16 '14 at 18:19

Xaphann

3,195
10
42
70

Are all of the potential fields that you're grouping on of the same type? – Servy Dec 16 '14 at 18:25
Can you provide an example of what you want to do? – crackhaus Dec 16 '14 at 19:13
You're not the first one... http://stackoverflow.com/q/10797997/861716, and many more. Did you try any of these solutions? – Gert Arnold Dec 16 '14 at 19:18
please read edit above – Xaphann Dec 16 '14 at 20:44
Try `it.Field1"` etc. – Gert Arnold Dec 16 '14 at 21:51
`"new(it.Field1, it.Field2", "it"` returns the same error – Xaphann Dec 16 '14 at 22:01

LINQ group by dynamic

0 Answers0