Switch Case in LINQ

Tweet

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

Tweet

About The Author

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.