Linq Gruping Dynamically

Question

Hi i want to write dynamic Grouping for my code.

string cc=GroupColumnName.LastOrDefault().ToString()

string dd = "Amit";

                    var categories =
         from p in kk  //KK List.
         group p by new
         {
             Sec = cc
         } into g
         select new { Category = g.Key, TotalUnitsInStock = g.Sum(p =>dd //Dynamic Columnname) };

how can I achieve this.

---

Amitsp

Answer 1

Hi Amit,

You can build dynamic LINQ queries using the LINQ Dynamic Query Library. Have a look here: http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx 

Regards,

Tyler

Answer 2

Hi I seen that URL but not related with Grouping? I need grouping with dynamic value.

---

Amitsp

Answer 3

Hi Amit,

You can refer this link here: http://blogs.msdn.com/b/mitsu/archive/2008/02/07/linq-groupbymany-dynamically.aspx

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.