C # Linq Group By en múltiples columnas

public class ConsolidatedChild { public string School { get; set; } public string Friend { get; set; } public string FavoriteColor { get; set; } public List Children { get; set; } } public class Child { public string School { get; set; } public string Name { get; set; } public string Address { get; set; } public string Friend { get; set; } public string Mother { get; set; } public string FavoriteColor { get; set; } } 

Dadas las dos clases anteriores, me gustaría utilizar LINQ para crear una lista de la lista, agrupada por las propiedades School, Friend y FavoriteColor. ¿Es esto posible con LINQ?

Por favor, ignore las propiedades, el código ha sido escrito solo para ayudar con la pregunta.

Fácil:

 var consolidatedChildren = from c in children group c by new { c.School, c.Friend, c.FavoriteColor, } into gcs select new ConsolidatedChild() { School = gcs.Key.School, Friend = gcs.Key.Friend, FavoriteColor = gcs.Key.FavoriteColor, Children = gcs.ToList(), }; 

Dada una lista:

 var list = new List() { new Child() {School = "School1", FavoriteColor = "blue", Friend = "Bob", Name = "John"}, new Child() {School = "School2", FavoriteColor = "blue", Friend = "Bob", Name = "Pete"}, new Child() {School = "School1", FavoriteColor = "blue", Friend = "Bob", Name = "Fred"}, new Child() {School = "School2", FavoriteColor = "blue", Friend = "Fred", Name = "Bob"}, }; 

La consulta se vería así:

 var newList = list.GroupBy(x => new {x.School, x.Friend, x.FavoriteColor}) .Select(y => new ConsolidatedChild() { FavoriteColor = y.Key.FavoriteColor, Friend = y.Key.Friend, School = y.Key.School, Children = y.ToList() } ); 

Código de prueba:

 foreach(var item in newList) { Console.WriteLine("School: {0} FavouriteColor: {1} Friend: {2}", item.School,item.FavoriteColor,item.Friend); foreach(var child in item.Children) { Console.WriteLine("\t Name: {0}", child.Name); } } 

Resultado:

 School: School1 FavouriteColor: blue Friend: Bob Name: John Name: Fred School: School2 FavouriteColor: blue Friend: Bob Name: Pete School: School2 FavouriteColor: blue Friend: Fred Name: Bob 
    Intereting Posts