lambda表达式多条件查询

最新推荐文章于 2024-07-03 02:11:52 发布

weixin_30639719

最新推荐文章于 2024-07-03 02:11:52 发布

阅读量1.6k

点赞数

文章标签： c# python

原文链接：http://www.cnblogs.com/wy1992/p/6904442.html

版权

并且，与或者：&&与||

clist = clist.Where(r => r.Price > 50 && r.Price < 60 || r.Price < 30).ToList();

包含：contains

 List<car> clist= new cardata().SelectAll().Where(r => r.Name.Contains(TextBox1.Text)).ToList();

等于：==

 clist = clist.Where(r => r.Price==40).ToList();

  clist = clist.Where(r => r.Price.Equals(40)).ToList();

以。。开始、以。。结束

 List<users> ulist = con.users.Where(r => r.username.StartsWith("s")).ToList();
            List<users> ulsit = con.users.Where(r => r.username.EndsWith("t")).ToList();

最大值、最小值、平均值、求和

 int s = con.users.Max(r=>r.ids);
            int t = con.users.Min(r=>r.ids);
            double h = con.users.Average(r => r.ids);
            int d = con.users.Sum(r => r.ids);

求交集

            List<users> ulist1 = new List<users>();
            List<users> ulist2 = new List<users>();
            List<users> ulist3 = new List<users>();
            List<users> ulist = ulist1.Intersect(ulist2).Intersect(ulist3).ToList();

顺序、倒序

            List<users> ulist = con.users.OrderBy(r => r.ids).ToList();
            List<users> ulist1 = con.users.OrderByDescending(r => r.ids).ToList();

转载于:https://www.cnblogs.com/wy1992/p/6904442.html