Linq To Sql - Dynamic OrderBy - Case When

dynamic, linq, linq-to-sql, sql-order-by

Solution

var u = from u in db.users
        orderby u.username == 100 ? 1 : 0 descending
        select u;

Problem

I'm using Linq to sql and Linq Dynamic OrderBy. I know linq dynamic can do simple sorting like - orderby("column_name"). But does it support something more complex like queries with "CASE WHEN" in them ? ``` string orderbyQuery = "(CASE WHEN (username == 100) THEN 1 ELSE 0 END) DESC)"; ``` here is my query : ``` var u = from u in db.users orderby(orderbyQuery) select u; ``` the above example doesn't work! , any idea if its possible? any other way to do it? thanks

Original source