[LINQ].NET/C#程序开发中如何使用LINQ查询前几条数据记录

问题描述

比如当前有如下的LINQ查询语句：

var list = from t in ctn.Items
           where t.DeliverySelection == true && t.Delivery.SentForDelivery == null
           orderby t.Delivery.SubmissionDate
           select t;

怎样写查询前几条数据的LINQ语句呢？

方案一

var list = (from t in ctn.Items
           where t.DeliverySelection == true && t.Delivery.SentForDelivery == null
           orderby t.Delivery.SubmissionDate
           select t).Take(5);

方案二

使用Lambda表达式的查询：

var list = ctn.Items
.Where(t=> t.DeliverySelection == true && t.Delivery.SentForDelivery == null)
.OrderBy(t => t.Delivery.SubmissionDate)
.Take(5);