Having trouble getting an SQL query converted to Linq to Entities

Question

I have the following SQL query:

SELECT Comment, JD, Jurisdiction, RegStatus, Region, SPDR_NAME 
FROM dbo.Registered_status_by_year 
GROUP BY Comment, JD, SPDR_NAME, Region, Jurisdiction, RegStatus 
HAVING (Region = @Region) ORDER BY JD

I am trying to convert it to linq to entities. I have the following, so far:

var result = (from x in myEntities.IRTStatusByYearSet
                          group x by new { x.Comment, x.JD, x.SPDR_NAME, x.Region, x.Jurisdiction, x.RegStatus } into g
                          select g);

The problem is that I can't seem to use the "orderby" because "g" doesn't have any "properties" that are the column names.

Does anyone know how I might do this? I have looked for examples of doing the order by with grouping, but all of them show only grouping by one thing, or ordering by the "count" of items in grouping, instead of by some other value.

Aducci · Accepted Answer · 2011-09-12 15:46:33Z

2

Have you tried orderby g.Key.JD?

var result = (from x in myEntities.IRTStatusByYearSet
              group x by new { x.Comment, x.JD, x.SPDR_NAME, x.Region, x.Jurisdiction, x.RegStatus } into g
              orderby g.Key.JD
              select g);

answered Sep 12, 2011 at 15:46

Aducci

26.8k8 gold badges67 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amanda Kitson Over a year ago

That is TOTALLY it.. thank you so much! I will mark this as answered as soon as the 10 mins is up. =)

Collectives™ on Stack Overflow

Having trouble getting an SQL query converted to Linq to Entities

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related