Convert SQL to LINQ

[User 2934748]

SELECT GRUP_CODE, MENUNO, CHOICECHAR, SUBCHAR FROM USERRGHT WHERE (GRUP_CODE = '01') ORDER BY CASE MENUNO WHEN 'P' THEN 1 WHEN 'E' THEN 2 WHEN 'A' THEN 3 WHEN 'F' THEN 4 WHEN 'H' THEN 5 END, CHOICECHAR I am new to .Net Framework 3.5. Please some one can convert this as a LINQ Statement. it will be very helpful for me.

[dan sh]

I find this[^] link quite useful. I hope you find it same. As far as case is concerned, you need to employ ternary operator(?: ) in LINQ's where clause.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

modified on Tuesday, October 13, 2009 12:35 PM

[thewomanindress]

Yes, it's useful.