Linq to SQL Case WHEN in VB.NET?

Question

How do I do a Case WHEN in Linq to SQL (vb.net please).

In SQL it would be like this:

SELECT 
CASE
  WHEN condition THEN trueresult
  [...n]
[ELSE elseresult]
END

How would I do this in Linq to SQL?

Answer 1

var data = from d in db.tb select new {

CaseResult = If (d.Col1 = “Case1”, "Case 1 Rised", If (d.Col1 = “Case2”, "Case 2 Rised", "Unknown Case"))

};

Answer 2

Check This Out

var data = from d in db.tb select new {

 CaseResult = (

 d.Col1 == “Case1” ? "Case 1 Rised" :

 d.Col1 == “Case2” ? "Case 2 Rised" :

 "Unknown Case")

 };

Please Note that [ ? Symbol = then] , [ : Symbol = Or].