Linq 基本查询操作

1.基本查询操作

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Anonymous_Lam { class Student { public string First { get; set; } public string Last { get; set; } public int ID { get; set; } public string City { get; set; } } class Linq_select_basic { static void Main() { //Create Data Source List<Student> Student_list = new List<Student>() { new Student { First = "Guo", Last = "Hu", ID = 1101, City = "shanghai" }, new Student { First = "Lei", Last = "Hu", ID = 1102, City = "wuhan" }, new Student { First = "Junwen", Last = "Li", ID = 1103, City = "wuhan" }, new Student { First = "Jinhao", Last = "Liu", ID = 1104, City = "taiyuan" } }; //create query var selectAll = from StudentInfo in Student_list where StudentInfo.City=="wuhan" orderby StudentInfo.Last descending select StudentInfo; //execute query foreach (var SInfo in selectAll) { Console.WriteLine("his name is {0}{1}",SInfo.First,SInfo.Last); } } } }

2.转换为XMl

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml; using System.Xml.Linq; namespace Anonymous_Lam { class Student { public string First { get; set; } public string Last { get; set; } public int ID { get; set; } public string City { get; set; } } class Linq_select_basic { static void Main() { //Create Data Source List<Student> Student_list = new List<Student>() { new Student { First = "Guo", Last = "Hu", ID = 1101, City = "shanghai" }, new Student { First = "Lei", Last = "Hu", ID = 1102, City = "wuhan" }, new Student { First = "Junwen", Last = "Li", ID = 1103, City = "wuhan" }, new Student { First = "Jinhao", Last = "Liu", ID = 1104, City = "taiyuan" } }; //create query var studentToXml = new XElement("Root", from students in Student_list select new XElement ( new XElement("student", new XElement("First", students.First), new XElement("last", students.Last), new XElement("City", students.City) ) )); //Execute query Console.WriteLine(studentToXml); } }