Switch Case in LINQ

Let us see how to derive conditional results using LINQ. This is a typical example of a switch case statement in LINQ.

In this example, we will print "Pass", "Fail" and "On Hold" depending on the 'Result' of the student. We are using a switch case pattern to determine the string. If the Result is 'P' we print 'Pass'; if the Result is 'F' we print 'Fail' else we print 'On Hold' if it is neither 'P' or 'F'.

C#


List<Student> stuList = new List<Student>();


stuList.Add(new Student() { ID = 1, FName = "Shakiy",Result = 'P' });


stuList.Add(new Student() { ID = 2, FName = "Mary", Result = 'P' });


stuList.Add(new Student() { ID = 3, FName = "Bill", Result = 'F' });


stuList.Add(new Student() { ID = 4, FName = "Samantha", Result = 'F' });


stuList.Add(new Student() { ID = 5, FName = "Mary", Result = 'P' });


stuList.Add(new Student() { ID = 6, FName = "John", Result = 'O' });


 


var slist = from stu in stuList


             select new { Name = stu.FName, Result = stu.Result  == 'P' ? "Pass" :


                 stu.Result == 'F' ? "Fail" : "On Hold" };


 


foreach (var list in slist)


{


    // print name and result


}




VB.NET


        Dim stuList As New List(Of Student)()


        stuList.Add(New Student() With {.ID = 1, .FName = "Shakiy", .Result = "P"c})


        stuList.Add(New Student() With {.ID = 2, .FName = "Mary", .Result = "P"c})


        stuList.Add(New Student() With {.ID = 3, .FName = "Bill", .Result = "F"c})


        stuList.Add(New Student() With {.ID = 4, .FName = "Samantha", .Result = "F"c})


        stuList.Add(New Student() With {.ID = 5, .FName = "Mary", .Result = "P"c})


        stuList.Add(New Student() With {.ID = 6, .FName = "John", .Result = "O"c})


 


        Dim slist = _


         From stu In stuList _


         Select New With {Key .Name = stu.FName, Key .Result = If(stu.Result = "P"c, "Pass", If(stu.Result = "F"c, "Fail", "On Hold"))}


 


        For Each list In slist


            ' print name and result


        Next list







About The Author

Suprotim Agarwal
Suprotim Agarwal, Developer Technologies MVP (Microsoft Most Valuable Professional) is the founder and contributor for DevCurry, DotNetCurry and SQLServerCurry. He is the Chief Editor of a Developer Magazine called DNC Magazine. He has also authored two Books - 51 Recipes using jQuery with ASP.NET Controls. and The Absolutely Awesome jQuery CookBook.

Follow him on twitter @suprotimagarwal.

2 comments:

Unknown said...

Tks for the article have a nice day!!

Anonymous said...

muy buendo !