Converting SQL Query to LINQ for EntityFramework

Question

I am having trouble translating following query to EF:

SELECT DISTINCT
[CompanyId]
,[CompanyNumber]
,[ReturnsLastMadeUpDate]
FROM [CHX].[dbo].[CompanyDetailsDailyDump]
WHERE [InsertDate] BETWEEN '2012-12-19' and '2013-01-20'
ORDER BY [ReturnsLastMadeUpDate] DESC

The main issue is with the Distinct(). How can I select above three specific columns to be compared for distinct rather than all the columns. Regards

Did you google it? .Distinct() would appear to be the answer. Why am I doing you google searches? — Dale M
– Dale M, Commented Jan 23, 2013 at 11:44
Yeah, but the distinct will compare all available columns rather than only three. If only specific columns are select able, this could also solve the problem. — as if
– as if, Commented Jan 23, 2013 at 11:48

DarkWanderer · Accepted Answer · 2013-01-23 11:47:06Z

1

You just need to apply Distinct after all other operations. I.e.:

CompanyDetailsDaily
    .Where(x => x.InsertDate < DateTime.Parse('2013-01-20') && 
            x.InsertDate > DateTime.Parse('2012-12-19'))
    .OrderBy(x => x.ReturnsLastMadeUpDate)
    .Select(x => new{x.CompanyID,x.CompanyNumber,x.ReturnsLastMadeUpDate})
    .Distinct();

Be careful with the date inclusion (one of the >/< symbols may need to be replaced with =>/<=)

answered Jan 23, 2013 at 11:47

DarkWanderer

8,8751 gold badge30 silver badges57 bronze badges

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

2 Comments

as if Over a year ago

Thank You very much, saved the day.

DarkWanderer Over a year ago

You're welcome! And welcome to Stack Overflow. Don't forget to accept and/or upvote answers to questions you've liked.

Collectives™ on Stack Overflow

Converting SQL Query to LINQ for EntityFramework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related