Hi all,
I have written a bit of linq where it gets data from the db in the form of
Id Name Category
1 Name1 Cat1
2 Name2 Cat1
3 Name1 Cat3
I am trying to merge Category column for same Ids, something like:
Id Name Category
1 Name1 Cat1, Cat3
2 Name2 Cat1
How is this possible in LINQ? My statement is
var query = from p in table
select new {p.Id, p.Name, p.Category}
Any help would be appreciated.
Thanks
concatenate rows
Here is one of possible solutions:
Code: Select all
List ncs = new List();
foreach (var el in from it in db.Namecategories group it by it.Name) {
string categories = null;
foreach (var cat in el) {
if (categories != null)
categories += ", ";
categories += cat.Category;
}
ncs.Add(new Namecategory
{
Name = el.Key,
Category = categories
});
}