C# linq group by

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);

View another examples Add Own solution

Log in, to leave a comment

4

4

Peajaypee 95 points

                                    var results = persons.GroupBy(
    p =&gt; p.PersonId, 
    p =&gt; p.car,
    (key, g) =&gt; new { PersonId = key, Cars = g.ToList() });

Thank you! 4

4 (4 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category C#

C# 2022-03-27 22:45:18 il c#
C# 2022-03-27 22:40:23 c# movement script
C# 2022-03-27 22:15:17 Delete last modification on EntityFramework Core
C# 2022-03-27 22:15:02 file.create folder c#
C# 2022-03-27 19:25:04 Error inflating class android.support.constraint.ConstraintLayout
C# 2022-03-27 19:15:02 top down shooting in unity 2D
C# 2022-03-27 18:50:02 c# remove invalid directory characters
C# 2022-03-27 18:30:07 how to use K2 games Games parallax background
C# 2022-03-27 18:25:10 c# replace crlf
C# 2022-03-27 18:25:09 keycode for left mouse click unity

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

grouping linq linq select where group by group by having linq c# linq group by order using a method in a group by linq a linq group clause results c# linq group by from datagrid c# linq group by from class c# linq group by class using groupby linq c# linq group by enums c# linq group by list of string c# linq groupby orderby c# linq group list by c# sql linq group by group by and order by linq c# select group by linq c# linq grouping linq group by aggregate linq group by in details c# group in c# linq linq group bu linq query group by c# group by linq to sql linq with group by example in c linq group by query in c# linq with group by example in c# groupby in linq c# linq c# group by example c# linq group by namew and occurrence .net linq GroupBy group by example in linq c# c# linq groupby equals linqu group by linq to sql group by example c# linq groupby example c# group by linq examples c# ling group by dot net : linq group by expressions c# linq group by select list linq groupby sql group by in group by linq linq expression group by c# sql linq group bu group by linq c# list .GroupBy linq c# linq group by valeus group by linq example with model c# group by in model linq c# group by linq example how use group by in linq to get all the data in c# linq where and group by c# group by select new linq c# C LINQ group by select c# linq group with where select query linq c# group from ... in group query linq c# group requete linq group by linq simple group by linq group by id c# group linq sql server group by linq c# linq group by foreach ling group by group by with where clause in linq c# total linq group by c# groupby linq c# linq group by and having list group by linq c# .net linq group by linq group by variable dynamic group by linq c# linq group c# select in group by linq c# linq group by and order by c# apply groupby by using linq on select list in c# c# linq group by from list linq sql group by group by where as linq c# linq group by docs linq to sql group rows by name linq to sql group by linq group by id sql dot net: group by linq examples linq group by where group linq c# linq: group by column c# linq group and select linq group by having group by on list of object in linq c# group by on list in linq c# group by and select in linq select linq groupeby c# c# linq group by all columns groupby in linq list c# where with group by linq linq group by select c# linq groupby example groupby c# linq group by select in linq c# syntax linq group by select to list c# linq group group by c# linq example group by clause in a linq query groupby clause in a linq query how to use list group by in linq c# linq c# group by from list to list linq c# group by from list linq gropu by c# linq query group by example where and group by linq c# linq group by columns group by in linq query c# c# linq group by select new object c# linq group. linq group by example in c# linq group by result c# c# linq group by select group by linq query in c# group by using linq linq group by get values c# linq group by sql format c# linq group by sql form c# group by linq linq group by and select linq query group by clause linq can use where for group by c# linq sql group by linq group by example linq group by vb.net group by linque linq group by asenumerable linq select and group by linq group by then order group by list group by c# linq linq query group by group by in linq c# group by in linqc# c# linq group by inside group by c# linq group select linq group by syntax c# linq group by expression linq group by into list linq grup by group by and return list linq group by and list linq C# linq groupby order by groupby linq c# example linq query syntax group by linq group by method syntax linq .select to group by c# linq to group by c# Groupby in linq linq groupby c# linq groupby c sharp group by linq linq with where and group by in c# linq where with group by c# c# linq group iwth or group by in linq method query c# group by linq list c# linq group by and take from each group linq query with group by in c# group clause in linq c# linq groupby c# group by id in linq c# can you group by in linq with a select can you group by in linq linq group linq to group linq group by example c# linq method syntax group by what does groupby linq query do linq example c# group by group by linq extract linq group by id linq group by each value in list c# linq grouping group by object c# linq groupby then select in linq c# where group by linq c# linq group by syntax c# c# linq method syntax groupby linq c# sintassi groupby group by clause in linq c# group by list in linq c# group by in linq group in linq group by with having clause in linq c# group by linq c# linq group by get field group by with having in linq c# group by in linq query syntax c# linq group by and project group by c# linq c# linq group by where linq select group by c# groupby linq examples sql query group results in linq linq group by list linq query group by with where clause group linq in c# c# linq group by on dataset c# linq group by example linq c# group by list<> group by and select in c#linq c# linq group into complex object use alementsù group into linq c# group by clause in linq Grouping c# c# group by linq example how to loop group by linq c# linq with group and where by c# list groupby c# c# ilist group by query syntax linq group by get object group by c# group by in linq lambda c# linq group by query syntax group by column linq linq with group by c# linq aplly groupby to a query c# linq to group by linq group by order by csharp linq group by get key Enumerable.GroupBy Method (System.Linq) groupby code example c# Grouping Results with LINQ c sharp Enumerable.GroupBy Method syntax c sharp group in linq c# linq group by c# group by lnq c# linq group by microsoft c# groupby example grouby linq linq with group group by linq group by in c# group by in linq query how to use group by in linq c# linq query group by select c# groupby linq squery c# linq with group by use group by in linq string.groupby c# group by example c# linq group by] c# linq query group by group by c# example how to do group by in linq c# linq group by linq group and where in linq c# how to use when after group clause in linq c# how to use the group by in C# c# group by Linq Groupe by use where in group by in linq c# linq group by c# group basic group by linq query asp.net groupby asp.net linq group by groupby in c group functions in dotnet core linq group by in c# c# groupby compare group of methods to group c# groupby linq linq query select group by linq groupby example c# linque group list using group by in c# group by in linq in c# GroupBy in C# GroupBy ion C# select key.value not getting in sql .net core group by in c# linq c# groupby linq linq group by C# linq group by

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example