LINQ groups by then orders result groups

.net c# entity-framework linq

Question

I have a table that has the following 3 columns, ID, ShortCode, UploadDate.

I want to use LINQ to group the results by shortcode (and keep all the results) then order those groups and return a list.

I have the following:

 rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
.ToList<PDFDocument>().
GroupBy(b=>b.ShortCode)
.SelectMany(b=>b).ToList<PDFDocument>()

I want to return all results, grouped by ShortCode, the items within each group sorted by UploadDate and the groups sorted so the one that has the most recent document in it first.

Does anyone know if this is even possible?

1
20
5/10/2012 9:08:12 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Try

rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
    .AsEnumerable()
    .OrderByDescending(d => d.UploadDate)
    .GroupBy(d => d.ShortCode)
    .SelectMany(g => g)
    .ToList();

This should

  • Order the items by upload date (descending so newest first)
  • Then group them by short code - so within each group the items are still sorted
  • The groups are still in descending order, so no need to order again
  • Finally concatenate the results into a single list

If performance is an issue you many be better off doing

rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
    .AsEnumerable()
    .GroupBy(d => d.ShortCode)
    .Select(g => g.OrderByDescending(d => d.UploadDate))
    .OrderByDescending(e => e.First().UploadDate)
    .SelectMany(e => e)
    .ToList();

which sorts the contents of each group separately rather than sorting everything first and then grouping.

42
4/1/2015 2:11:52 PM

Popular Answer

In fact, you don't want to group by short code, you want to order by them. So the following query should do the trick:

rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
.ToList()
.OrderBy(b => b.ShortCode)
.ThenBy(b => b.UploadDate)
.ToList()

Edit If you really want to use a GroupBy, you can do so this way:

 rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
.ToList()
.GroupBy(b => b.ShortCode)
.SelectMany(grouping => grouping.OrderBy(b => b.UploadDate))
.ToList()

But I discourage it. There is no point creating groups if you do not want groups in the first place!

Second edit

I did not get you wanted the groups ordered by UpdateTime too. It complicates a little the query:

rawData.Provider.CreateQuery<PDFDocument>(qb.rootExperession)
.ToList()
.GroupBy(b => b.ShortCode)
.Select(grouping => grouping.OrderByDescending(b => b.UploadDate))
.OrderByDescending(grouping => grouping.First().UploadDate)
.SelectMany(grouping => grouping)
.ToList()
Falanwe

Related Questions

"Group By" and/or "Order By" in the entity framework

Salut!...I'm going to guess at your data model a little, here, but I don't think you need to group:...var query = from details in m_context.TransactionDetails where details.Chanson != null orderby details.Items.Count() descending select new Item { IdItem = details.Chanson.IdItem, ...
asp.net c# entity-framework visual-studio-2008
asked by Craig Stuntz

Join two tables using LINQ to Entities, then group and total the columns from each tables.

the transaction variable is out of scope. If you include it in you grouped result then you can use it....change you group by clause to:...group new { target, transaction } by new { target.ProductGroupID, target.StateID, target.Year } into grouped ...
c# entity-framework linq linq-to-entities
asked by saus

Entity framework where, order and group

entity.Results .Where(m => m.Group == 0 || m.Group == 1) .GroupBy(m => m.UserID) .Select(m => new { User = m.Key, TotalPoints = m.Sum(v => v.Points) }) .OrderByDescending(m => m.TotalPoints);
c# entity-framework linq
asked by Asif Mushtaq

Entity Framework with Linq, inner Join, Group By, Order By

I have a SQL Query...select Firma.Name as companyName, Taetigkeit.Taetigkeit as skillName, SUM(Zeit) as time from Zeiterfassung inner join Firma On ZEiterfassung.FirmenID = Firma.ID inner join Taetigkeit on Zeiterfassung.TaetigkeitID = Taetigkeit.ID group by Taetigkeit, Firma.Name order by Firma.Name ...And want to "tr...
c# entity-framework linq linq-to-entities sql
asked by Markus_DE_HH

Entity Framework - Linq query with order by and group by

I have ...Measurement... Objects with the relevant Properties ...CreationTime... (DateTime) and ...Reference... (String) and some other values....I'd like to write an efficient linq query to a ...DbContext... that ...groups my ...Measurement... objects by a given ...Reference...orders the groups by either the ...CreationTime... Property of the firs...
c# entity-framework linq mysql
asked by zufallsfund

How to select Distinct / Group By child property in both LINQ method and syntax?

I have class...public class Parent { [Key] public int ParentID { get; set;} public virtual ICollection<Child> Childs { get; set; } } public class Child { [Key] public int ChildID { get; set; } public int Grade { get; set; } public int ParentID { get; set; } [ForeignKey("ParentID")] public virtual Parent Parent ...
c# entity-framework entity-framework-6 linq
asked by warheat1990

Entity Framework: Order by and then group by

I think what you are looking for is something like this:...var audits = (from a in context.LogEntries group a by a.CorrelationId into grp let logentries = grp.OrderByDescending( g => g.TimeStamp) select new AuditTrail { CorrelationId = grp.Key, ...
c# entity-framework entity-framework-6
asked by octavioccl

LINQ to SQL - order by, group by and order by each group with skip and take

You can take another approach using ...Max... instead of ordering each group and taking the first value. After that you can order by max grade, name (in case two students have the same max grade) and grade:...var query = c.Customers .GroupBy(s => s.Name, (k, g) => g .Select(s => new { MaxGrade = g.Max(s2 => s2.Grade), Student = s })) ...
c# entity-framework-6 linq linq-to-sql
asked by arekzyla

Order by descending group by Max date, then order by single row in the group by date ascending using linq Method sintax

I suggest creating an intermediate result having a ...GroupDate... property. In my example I am using ...C# 7.0 Tuples.... You could use anonymous types as well, if you are using an older C# version....var result = messages .GroupBy(m => m.GroupId) // Create Tuple ... .Select(g => (Group: g, GroupDate: g.Max(m...
c# entity-framework-6 linq sql sql-server
asked by Olivier Jacot-Descombes

How to select records with MAX Id that group by multiple columns in LINQ to SQL

I need to select the last record of particular columns. I have the following records...WarehouseId | ItemId | SubItemId | DeliveryGroupId | Other Columns 1 | 1 | 1 | 1 | ... 1 | 1 | 1 | 2 | ... 1 | 1 | 1 | 3 | ... 1 ...
c# entity-framework-6 linq-to-sql
asked by Sam

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow