If Statement within Linq Query

Question

I am attempting to sort dropdownlist just exactly how it is entered in the database only if a specific id is selected. Otherwise I want them to sorted in ascending order. I was not sure how to add the final component of not sorting the list when a particular Id is selected. Here is where i am so far:

var items = (from p in _db.Funds
                     where p.DesignationId == id
                     orderby p.Name ascending 
                     select new { p.id, p.Name });
        return items;

What do you mean by "exactly how it is entered in the database"? You should regard rows in a database table as unordered unless you specify an ordering. — Jon Skeet
– Jon Skeet, Commented Jul 18, 2013 at 18:18

p.s.w.g · Accepted Answer · 2013-07-18 18:28:05Z

8

You mean something like this?

var items = 
    (from p in _db.Funds
     where p.DesignationId == id
     select new { p.id, p.Name });
if (id != "some id")
{
    items = items.OrderBy(p => p.Name);
}

return items.ToList();

edited Jul 18, 2013 at 18:28

answered Jul 18, 2013 at 18:17

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

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

9 Comments

Felipe Oriani Over a year ago

Just remember to call ToList() method to execute your query.

Paradigm Over a year ago

p.DesignationId is the Id i wanted it to be based on

evanmcdonnal Over a year ago

This works but wouldn't it perform better if you determined the ordering before hand and made it so orderby is part of the LINQ to SQL query rather than a LINQ to Objects query done after?

p.s.w.g Over a year ago

@evanmcdonnal The ordering will be executed as a Linq-to-SQL / -Entities query.

p.s.w.g Over a year ago

@Paradigm So... if no id is selected display everything unordered; if some id is selected just display those items, ordered by Name. Is that right?

|

Abbas Amiri · Accepted Answer · 2013-07-18 19:10:51Z

2

It would be a solution

var items = (from p in _db.Funds
                 where p.DesignationId == id
                 orderby p.id == "the id" ? p.Name : null 
                 select new { p.id, p.Name });
return items;

answered Jul 18, 2013 at 19:10

Abbas Amiri

3,2241 gold badge27 silver badges25 bronze badges

Collectives™ on Stack Overflow

If Statement within Linq Query

2 Answers 2

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related