HOW TO FORCE ORDER BY LINQ

Suresh Jayaraman

11y2.3kLINQ

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rahul Singh11y ago
This will work:-

List > result = db.Countries.OrderBy(x => x.CountryName == "INDIA" ? "1" : (x == "CHINA" ? "2" : x)).ToList();
0
Vulpes11y ago
Try this:

var query = from c in db.Country orderby
(
c.CountryName == "India" ? "1" :
c.CountryName == "China" ? "2" :
c.CountryName
)
select c;
0
Ananth Padmanabham vemula11y ago
Hi Suresh,

I hope below query will useful for you.

var getdata = (from i in dc.Country select i).OrderBy(x => x.CountryName);
0