linq -select case when-

using (SchoolEntities sc = new SchoolEntities())

02

{

03	var query = from grade in sc.StudentGrade

04	join student in sc.Person on grade.Person.PersonID

05	equals student.PersonID

06	select new

07

{

08	FirstName = student.FirstName,

09	LastName = student.LastName,

10	Grade = grade.Grade.Value >= 4 ? "A" :

11	grade.Grade.Value >= 3 ? "B" :

12	grade.Grade.Value >= 2 ? "C" :

13	grade.Grade.Value != null ? "D" : "-"

14

};

15

16	foreach (var q in query)

17

{

18	Console.WriteLine("{0} {1} has {2} grade", q.FirstName, q.LastName, q.Grade);

19

}

20	Console.Read();

21

}