Generate a CASE statement in LINQ to SQL

If you're wondering how to generate a Case statement by using LINQ to SQL here's how. I also go over how to concat case statements... And by the time you get to the end you should understand how to nest case statements as well :)