HOW TO FORCE ORDER BY LINQ

Question

Hi Can any one please help

I like to do custom sort using linq ,

Below is the sample to do in SQL Server. I like to do using LINQ

USE [SqlAndMe]  GO   SELECT CountryName  FROM   dbo.Country  ORDER BY CASE WHEN CountryName = 'INDIA' THEN '1'                WHEN CountryName = 'CHINA' THEN '2'                ELSE CountryName END ASC  GO

CountryName

INDIA

CHINA

AUSTRALIA

BANGLADESH

FRANCE

JAPAN

NEW ZEALAND

PAKISTAN

SRI LANKA

UNITED KINGDOM UNITED STATES

Rahul Singh · Answer

This will work:- List > result = db.Countries.OrderBy(x => x.CountryName == INDIA ? 1 : (x == CHINA ? 2 : x)).ToList();

Vulpes · Answer

Try this: var query = from c in db.Country orderby ( c.CountryName == India ? 1 : c.CountryName == China ? 2 : c.CountryName ) select c;

Ananth Padmanabham vemula · Answer

Hi Suresh I hope below query will useful for you. var getdata = (from i in dc.Country select i).OrderBy(x => x.CountryName);