Order by in dynamic Linq expression

How can i use orderby to a colum Rank ( which i s created dynamicaaly based on some conditions) instaed of LastUpdated

var rrrr = (from item in dbContext.Blogs
                                orderby item.LastUpdated descending
                                select new
                                {
                                    item,
                                    Rank = item.Title.Contains("title") ? 4 :
                                            item.Author.Contains("author") ? 3 :
                                            item.Tag.Contains("tagname") ? 2 :
                                            0
                                });

Is it possible to use OrderBy on Rank (cynamically created column ) ? If yes how can can i do that else what are the other ways to do achieve this

Re: Order by in dynamic Linq expression

make a .ToList and then make an OrderBy in memory

make a calculated column in database( preferred)

Re: Order by in dynamic Linq expression

var rrrr = (from item in dbContext.Blogs
                                orderby item.LastUpdated descending
                                select new
                                {
                                    item,
                                    Rank = item.Title.Contains("title") ? 4 :
                                            item.Author.Contains("author") ? 3 :
                                            item.Tag.Contains("tagname") ? 2 :
                                            0
                                }).OrderByDescending(i=>i.Rank);

Is working for me.. i am not sure about the perfomance of this querry in a working environment (extract from thousands of records ) and sort in memory .. Is it a good way?

Re: Order by in dynamic Linq expression

mMATHAI
Is it a good way?

I think sobecause your Rank doesn't belong to your table and it's only a type of an anoymous property of the anoymous class

Reguards

Re: Order by in dynamic Linq expression

I am not sure about the perfomance, but it works fine for me on a table with thousands of rows..