static void Main(string[] args) { //Method Syntax var MS = Student1.GetAllStudents().OrderBy(x => x.Branch).ToList(); var MS1 = Student1.GetAllStudents(). Where(std => std.Branch.ToUpper() == "CSE"). OrderBy(x => x.FirstName).ToList(); //Query Syntax var QS = (from std in Student1.GetAllStudents() orderby std.Branch select std); foreach (var student in MS) { Console.WriteLine(" Branch: " + student.Branch + ", Name :" + student.FirstName + " " + student.LastName); } Console.WriteLine(); foreach (var student in MS1) { Console.WriteLine(" Branch: " + student.Branch + ", Name :" + student.FirstName + " " + student.LastName); } Console.ReadKey(); }
static void Main(string[] args) { //Method Syntax var MS = Student1.GetAllStudents() .OrderBy(x => x.Branch) //first level sort .ThenByDescending(y => y.FirstName) //second level sort .ToList(); foreach (var student in MS) { Console.WriteLine(student.Branch + " - " + student.FirstName); } Console.ReadKey(); }
static void Main(string[] args) { //Using Method Syntax var GroupByMS = Student1.GetAllStudents().GroupBy(s => s.Branch); //Using Query Syntax IEnumerable <IGrouping <string, Student1> > GroupByQS = (from std in Student1.GetAllStudents() group std by std.Branch); //It will iterate through each groups foreach (var group in GroupByMS) { Console.WriteLine(group.Key + " : " + group.Count()); //Iterate through each student of a group foreach (var student in group) { Console.WriteLine(" firstName :" + student.FirstName + ", lastname :" + student.LastName + ", id: " + student.ID); } } Console.Read(); }