学步园

using System;<br /> using System.Data;<br /> using System.Configuration;<br /> using System.Linq;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Text;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Web.UI.HtmlControls;<br /> using System.Collections.Generic;<br /> using System.Collections;</p> <p>public partial class _Default : System.Web.UI.Page<br /> {<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> //格式化化查询结果格式化化查询结果<br /> Response.Write("<hr>格式化化查询结果：<br>");<br /> string[] stringArray = { "Ajax", "Csharp", "Javascript", "Css Desige", "Asp.net", "Gis" };<br /> var books = from n in stringArray<br /> where n.Length >= 6<br /> select "I'm studying " + n;</p> <p> foreach (var book in books){<br /> Response.Write(string.Format("<div class='result'>{0}</div>", book));<br /> }</p> <p> //只查询合适对象集合的某个属性<br /> Response.Write("<hr>只查询合适对象集合的某个属性：<br>");<br /> List<Student> StudentList = GetStudents();<br /> var students1 = from n in StudentList<br /> where n.Language == "Chinese"<br /> select n.Name;</p> <p> foreach (var student in students1)<br /> {<br /> Response.Write(string.Format("<span class='result'>{0}</span>", student));<br /> }</p> <p> //从一个集合中查询，转化到另外一个集合<br /> Response.Write("<hr>从一个集合中查询，转化到另外一个集合：<br>");<br /> int[] intArray = { 3, 1, 6, 4 };<br /> var students2 = from n in intArray<br /> select StudentList[n];</p> <p> foreach (var student in students2)<br /> {<br /> Response.Write(string.Format("<span class='result'>{0}</span>", student.Name));<br /> }</p> <p> //构建匿名类型<br /> Response.Write("<hr>构建匿名类型：<br>");<br /> var stu = from n in intArray<br /> select new { Id = n, Name = StudentList[n].Name };</p> <p> foreach (var s in stu)<br /> {<br /> Response.Write(string.Format("<div class='result'>id:{0}; name:{1}</div>", s.Id,s.Name));<br /> }</p> <p> //构建匿名类型2——扩展已有类<br /> Response.Write("<hr>构建匿名类型2——扩展已有类：<br>");<br /> var students3 = from n in intArray<br /> select new { Id = n, StudentList[n].Name, StudentList[n].Age };</p> <p> foreach (var student in students3)<br /> {<br /> Response.Write(string.Format("<div class='result'>id:{0}; name:{1}; age:{2}</div>", student.Id, student.Name, student.Age));<br /> }</p> <p> //select的Lambda表达式<br /> Response.Write("<hr>select的Lambda表达式：<br>");<br /> var students4 = intArray.Select(i => new { Id = i, StudentList[i].Name });</p> <p> foreach (var student in students4)<br /> {<br /> Response.Write(string.Format("<div class='result'>id:{0}; name:{1}</div>", student.Id, student.Name));<br /> }</p> <p> // 复合选择<br /> Response.Write("<hr>复合选择：<br>");<br /> var study4 = from a in StudentList where a.Age>23<br /> from b in stringArray where b.Length>8<br /> select new {name=a.Name,book=b};<br /> foreach (var student in study4)<br /> {<br /> Response.Write(string.Format("<div class='result'>{0} is studying {1}</div>", student.name, student.book));<br /> }</p> <p> //多重选择<br /> Response.Write("<hr>多重选择：<br>");<br /> var study =<br /> from a in StudentList<br /> where a.Age > 20<br /> from b in stringArray<br /> where b.Length > 5<br /> select new {a.Name,book=b};</p> <p> foreach (var s in study)<br /> {<br /> Response.Write(string.Format("<div class='result'>name:{0}; book:{1}</div>", s.Name, s.book));<br /> }</p> <p> //多重选择的Lambda表达式<br /> Response.Write("<hr>多重选择的Lambda表达式：<br>");<br /> var study1 = StudentList.SelectMany(student => stringArray.Select(str => student.Name + " has a book names " + str));</p> <p> foreach (var s in study1)<br /> {<br /> Response.Write(string.Format("<div class='result'>{0}</div>", s));<br /> }<br /> }</p> <p> //构造一个学生集合体<br /> private List<Student> GetStudents()<br /> {<br /> List<Student> students = new List<Student> {<br /> new Student{ Name="YOUNG", Age=25, Language="Chinese"},<br /> new Student{ Name="JESSIE", Age=21, Language="Scotland"},<br /> new Student{ Name="KELLY", Age=18, Language="English"},<br /> new Student{ Name="JUNE", Age=20, Language="English"},<br /> new Student{ Name="ADRIAN", Age=22, Language="Italy"},<br /> new Student{ Name="BRUCE", Age=17, Language="Scotland"},<br /> new Student{ Name="BRANT", Age=30, Language="Germany"},<br /> new Student{ Name="BEN", Age=25, Language="Chinese"}<br /> };<br /> return students;<br /> }<br /> }</p> <p>//学生类<br /> class Student<br /> {<br /> public int Age { get; set; }<br /> public string Name { get; set; }<br /> public string Language { get; set; }<br /> }

结果：

转自：http://www.cnblogs.com/young18/archive/2007/06/05/772127.html