Using if statement in Linq query

Question

For the following scenario:

Id  Total points    Correct Trends
1       12                8
2       12                4
3       10                5
4       10                7
5       10                2

Lets say I am the person with Id = 3.

I want to calculate the Ids which have Total points and Correct Trends greater than me.

If I use the below query then I will not get the user with Id=2 as his Correct Trends is less then mine.

var allAbove = (from item in userQuery
               where (item.Id!= myData.Id && 
               item.TotalPoints >= (myData.TotalPoints) &&
               item.CorrectTrends >= (myData.CorrectTrends) )

I am not able to find a way to check that when Total Points are equal then look for Correct Trends other wise check for Total Points only

René Vogt · Accepted Answer · 2016-06-15 12:25:21Z

2

The logic is actually straight forward:

var allAbove = (from item in userQuery
           where (item.Id!= myData.Id && 
           item.TotalPoints > myData.TotalPoints ||
           (item.TotalPoints == myData.TotalPoints && 
           item.CorrectTrends >= myData.CorrectTrends)));

It checks if either total points is greater or total points are equal and correct trends are greater.

answered Jun 15, 2016 at 12:25

René Vogt

44.1k15 gold badges84 silver badges106 bronze badges

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

1 Comment

Kamran Over a year ago

It was too easy but my mind is locked at the moment. Thanks a lot :)

Sergey Kalinichenko · Accepted Answer · 2016-06-15 12:25:47Z

1

Since you want to use CorrectTrends only for tie breaking, the correct expression should look like this:

item.Id!= myData.Id && (
       item.TotalPoints > myData.TotalPoints      // "Wins" on total points
||    (item.TotalPoints == myData.TotalPoints     // Same total points,
    && item.CorrectTrends > myData.CorrectTrends) // but higher correct trends
)

Note that >= need to be replaced with > to avoid items with ties.

answered Jun 15, 2016 at 12:25

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

Comments

Alex · Accepted Answer · 2016-06-15 12:33:05Z

0

Since i like method chain more:

var you = items.Where(x=>x.Id == myId).FirstOrDefault();
var allAbove = items.Where(x=>x.Id!=you.Id)
.Where(x=>x.TotalPoint>you.TotalPoints || x.CorrectTrends>you.CorrectTrends);

I'll let you do the null checking :)

answered Jun 15, 2016 at 12:33

Alex

3,9031 gold badge24 silver badges34 bronze badges

Collectives™ on Stack Overflow

Using if statement in Linq query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related