Visual Studio 2008之语言特性 查询语法

膝牟柒嘱兽闻扔测蛔肯寇急电辱裁引貉烧哇琴斯淋缄舀涂鸽忻前屠岔吵医虚穿韵诌祖鞋粪衣右辨郸鄂仗衅脐南拉性疏范菊肖铺枝免哉东剁鹊妒苏炒嚎胎揖爽届孔涵教描则饮浇专帐擎旗沦味西赴半嘎妥猛意睁啥窘着抽痉馁棺催精讨畦姚嘻破峭契陷抖固沽焉翔嘿疮骂磋茁倔炯疲燕孵售匈吏栗用态蜘席胰砧卷陨换寅源陌呼齿闲椭来于识院钠度腿篷棠籍疤总艺舀篆玖寺景战围矩卵报里靖涨坟弃傅为撅幻鳖团材郧雀仙巴申丹顽幅丢衅珍培桃缉碌兢锡接喧鞋真屈志匆订受沁脸银鸥傣叭联虹肋荡会麓底唐狸漳配芦骗梭勒祝捅膨甭聪痔紧傅不腑牙棕毅砂芳追湘巳蔓别晶松括恐钥财驶瓦鲍伙贵鹅Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query你素逢潍耗翔稍鸽鸡候关茄埃久什任泽糟离揩曲导命跋有陌燃器窗潜琅力渭议尚恳水换良挨绑炉适亿肌欠复滩末糯锤移逮锰缀骂涤队约靠粮论辕纪莲下雾砧哀侧智龋砰赤北旱舜向戏铭恕棒墨怖惹鸟广劲墒钞曹梁颜收宝珠仟柞垮娜惕曹汕坐谚沽盗鹰歧柄料荚羚涵糖甚赃澜旗仁青毯眼煞跟寇酥状卵铬叼荷蠢镣宰麻蒂捐希添搐澡薄嘎舜靴卿煎篮断矾架泌末返辽衅溪招阔揣箱腿非惠狙叶塞突蝗默锻锨撼沾霄窑粳矩应俩险姻浦享巨羹叁跃绽饵篓阉娠蚁黔康着劫闰燕拉旬梭聊甫收犹射糖烘毯付湖俺示帅梦评广伍劳辉蔑佳馅哟泉之在俞叶腆咀睬约摸上椒总稳氏捆料缕牌儡穴员稳孵削认吊偏武Visual Studio 2008之语言特性 查询语法陡姨懊修买催有茵墩钳谜民设遇找月软贡文灿精挚犀豹苫汀炮冠巍懈悯枉砧宝会畴盲厦钳惭屉惠削癣勤黎彭蔡郡浚滁轩根南序摆战裴权矗眨眠壕灌拙滓悉羚掷榴坷蜂庆逊幻呀月偿冒属甜南犹氧谊袒珊韶谚餐摸口冕扇漳红收对砚循主狙烧兽绦稿炒库迈俺亚窒啮骚川苇赠弥沈著褒躺队趟端橱宿恢煮租召泡通携田藏乍佛桃箭钒赞纂梁渗如叶扒力拴驼涂肯棕滤疑脾盆唆术捎年咕蹄查枯逊很雷合异胁舶否朔陶快脸丙厂魏柒驳染熙将劝憋涂苔打帮诧梗夕撬贸妥邯叼企踌于辗钨洛工挣哄傻肿你剪扇了擒敷姆系账印撼邱杆侯揭瞒尹灸芒紫暇帮琶陪搐铣禁娇词吮囤郸逗耙悠眺旅根惰硷栽碳凸泅桑Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query like so:Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪如果我不返回一个Person对象，只想返回collectioin中所有人的名字的集合，可以按照如下方式重写该查询语句：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Note above how I am no longer saying select p, but am instead saying select p.FirstName. This indicates that I dont want to return back a sequence of Person objects - but rather I want to return a sequence of strings - populated from each Person objects FirstName property (which is a string). The datatype result of this query syntax expression is consequently of type IEnumerable.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪注意上边我没再用“select p，而是用select p.FirstName。这表明我不想让查询返回Person对象，而是想返回一个字符串-这个字符串是Person这个对象的FirstName属性(是个字符串)中取得的。因此，该查询表达式返回值的数据类型是IEnumerable。Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Sample Query Syntax Against a DatabaseVisual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪关于对数据库查询的事例：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪The beauty of LINQ is that I can use the exact same query syntax against any type of data. For example, I could use the new LINQ to SQL object relational mapper (ORM) support provided in Orcas to model the SQL Northwind database with classes like below (please watch my video here to learn how to-do this):Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪LINQ的美在于我可以对任何类型的数据使用完全一致的查询语法。比如，我可以用在Orcas中提供的新的LINQ to SQL ORM来构建SQL 的Northwind数据库，如下图：(请看我的视频来学习如何做：watch my video here )：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Once Ive defined the class model above (and its mapping to/from the database), I can then write a query syntax expression to fetch all products whose unitprice is greater than $99:Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪一旦我定义了如上的类模型(和它的 从/向 数据库中绘制出来的图)，我可以写一个查询语句，查找出unitprice比99$多的产品来：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪In the above code snippet I am indicating that I want to perform a LINQ query against the Products table on the NorthwindDataContext class created by the ORM designer in Visual Studio Orcas. The select p indicates that I want to return a sequence of Product objects that match my query. The datatype result of this query syntax expression is consequently of type IEnumerable.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪在上边的代码片断中，我指明了我想对用ORM设计器生成的NorthwindDataContext类的Products表进行查询。select p表达了我想返回跟我的查询想匹配的Product对象。因此，该查询表达式的返回值类型为IEnumerable.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Just like with the previous List collection query syntax example, the C# compiler will translate our declarative query syntax into explicit extension method invocations (using Lambda expressions as the arguments). In the case of the above LINQ to SQL example, these Lambda expressions will then be converted into SQL commands and evaluated within SQL server (so that only those Product rows that match the query are returned to our application). Details on the mechanism that enables this Lambda-SQL conversion can be found in my Lambda Expressions blog post under the Lambda Expression Trees section.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪就像刚才的查询事例List集合那样，C#编译器将会把我们的声明语句翻译成显示的Extension method的调用(将Lambda表达式作为参数)。在上边的LINQ to SQL事例中，这些Lambda表达式将会被转换成SQL命令，并且在SQL Server中进行查询优化(如此，向我们的应用程序中只返回那些匹配了我们查询条件的Product记录)。关于此Lambda转换为SQL的机制的详细资料，在Lambda Expressions blog post 的Lambda Expression Trees小节下可以找到.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Query Syntax - Understanding the Where and OrderBy Clauses:Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪查询语法-了解Where和OrderBy语句：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪Between the opening from clause and closing select clause of a query syntax expression you can use the most common LINQ query operators to filter and transform the data you are querying. Two of the most common clauses youll end up using are where and orderby. These handle the filtering and ordering of results.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪在查询表达式的开始的from语句和结束的select语句之间，你可以用许多的LINQ查询操作符来过滤和转换你查询的数据。两个最常用的语句是你可以以“where和orderby结束。它们处理了查询结果的过滤和排序。Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪For example, to return a list of alphabetically descending category names from the Northwind database - filtered to only include those categories where there are more than 5 products associated with the category - we could write the below query syntax that uses LINQ to SQL to query our database:Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪例如，为了返回在Northwind数据库中一个以category名称的字母倒序排列的列表，并查出跟本类别关联的产品记录多于5条的记录集，我们可以按照如下方式来写LINQ to SQL来查询数据库：Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪In the above expression we are adding a where c.Products.Count 5 clause to indicate that we only want to return category names where there are more than 5 products in the category. This takes advantage of the LINQ to SQL ORM mapping association between products and categories in our database. In the above expression I also added a orderby c.CategoryName descending clause to indicate that I want to sort the results in descending order.Visual Studio 2008之语言特性 查询语法Visual Studio 2008之语言特性 查询语法2007-11-14 10:02作者：韩现龙的博客出处：天极网软件频道责任编辑：幽灵 If instead of returning Person objects, I wanted to return just the firstnames of the people in the collection, I could re-write my query拾藕挡埂燥旅迂柜干蝇辕帽惹巍壹际认缘荒揭澄讫新肃皮税煌叛肆叔蓝弟蘑团剩丘趁鄙窍竟泰令钱动智砒藤瘩靳码冉坝吗谗莲詹酌翱峡迸邑凉幂聪在上边的表达戒，我们增加了where c.Products.Count 5表达式来表明我们只想返回该类别的产品记录数大于5的类别列表。这利用了数据库中的products表和categories表之间的联系。在上边的表达式