group by c#
public class DeliverableGroupContainer
{
public Crew Crew;
public DateTime Date;
public List<Deliverable> Deliverables;
}
List<DeliverableGroupContainer> Deliveries =
Db.Deliveries
.Where(d => d.CrewId != null)
.GroupBy(d => new {d.Crew, d.Date})
.OrderBy(d => d.Key)
.Select(g => new DeliverableGroupContainer()
{
Crew = g.Key.Crew,
Date = g.Key.Date,
Deliverables = g.ToList()
})
.ToList();
//------------------------------Example----------------------------------
var drAll3 = dt.AsEnumerable().GroupBy(d => new { d.Field<DateTime>("date").Date, V = d.Field<String>("supplierArticle") })
.Select(g => new { _Date = g.Key.Date , Article = g.Key.V, Qty = g.Sum(r => r.Field<int>("quantity")) }).ToList();
DataTable dt4 = StatHellpers.LINQResultToDataTable(drAll3);
0
0
var results = persons.GroupBy(
p => p.PersonId,
p => p.car,
(key, g) => new { PersonId = key, Cars = g.ToList() });
Thank you!
0
0
3
2
var results = from p in persons
group p.car by p.PersonId into g
select new { PersonId = g.Key, Cars = g.ToList() };
Thank you!
2
0
4.4
5
//Method Syntax
List<Result> results2 = persons
.GroupBy(p => p.PersonId,
(k, c) => new Result()
{
PersonId = k,
Cars = c.Select(cs => cs.car).ToList()
}
).ToList();
Thank you!
5
0
Are there any code examples left?
New code examples in category C#