Order by with condition

Question

I want to get the records with "Restricted" at top. here Is my query:

var records = (from entry in db.Table1
                    orderby entry.Always_Prohibited                              
                    select new
                           {
                                 RowID = entry.RowID,
                                 VehicleMake = entry.Make,
                                 VehicleModel = entry.Model,
                                 Restricted = (entry.Always_Prohibited == null || entry.Always_Prohibited == "False") ? "Restricted" : "Not Restricted"
                           }).ToList();

I tried by Orderby but it is not working because entry.Always_Probibited is a string field. Please suggest me.

Possible duplicate of [LINQ Order By Descending with Null Values on Bottom](http://stackoverflow.com/questions/26186527/linq-order-by-descending-with-null-values-on-bottom) — Jonnus, Nov 23 '15 at 22:36

score 1 · Answer 1 · answered Nov 23 '15 at 22:36

If you have only two values, simply order descending:

from entry in db.Table1
orderby entry.Always_Prohibited descending

If you have more, assign integer values to your strings:

from entry in db.Table1
orderby entry.Always_Prohibited=="A" ? 0 : entry.Always_Prohibited=="B" ? 1 : 2 // and so on

As a side note, strings are a pretty terrible way of storing state in databases. You should redesign it to store it as well defined integers (preferably as foreign keys in master lookup tables, ie strongly typed enums).

score 0 · Answer 2 · answered Nov 24 '15 at 09:01

User then below give code. It will help to you.

var records = (from entry in db.Table1.AsQueryable();
                orderby entry.Always_Prohibited                              
                select new
                       {
                             RowID = entry.RowID,
                             VehicleMake = entry.Make,
                             VehicleModel = entry.Model,
                             Restricted = (entry.Always_Prohibited == null || entry.Always_Prohibited == "False") ? "Restricted" : "Not Restricted"
                       }).ToList();

Order by with condition

2 Answers2