AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

Linq复杂对象查询

2018-01-07 1105
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：

复杂的查询对象，

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select c;
            Console.WriteLine("亚洲的有:");
            foreach (Customer c in queryResults)
            {
                Console.WriteLine(c);
            }

            Console.ReadLine();
        }
    }
}

查询对象的某个元素

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select c.City;
            Console.WriteLine("亚洲的城市有:");
            foreach (String city in queryResults)
            {
                Console.WriteLine(city);
            }

            Console.ReadLine();
        }
    }
}

查询结果只能是字符串，或者一个对象

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select new { c.City, c.Country };
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

用Select函数

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   where c.Region == "Asia"
            //                   select new { c.City, c.Country };
            var queryResults = customers.Where(c => c.Region == "Asia").Select(c => new { c.City, c.Country });
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

去重处理Distinct方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   where c.Region == "Asia"
            //                   select new { c.City, c.Country };
            var queryResults = customers.Select(c => c.Region).Distinct();
            Console.WriteLine("洲有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

any，All查询

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };


            // Any All
            bool anyUSA = customers.Any(c => c.Country == "USA");
            if (anyUSA)
            {
                Console.WriteLine("有些人是美国的");
            }
            else
            {
                Console.WriteLine("没有美国的");
            }

            bool allAsia = customers.All(c => c.Region == "Asia");
            if (allAsia)
            {
                Console.WriteLine("全是亚洲的人");
            }
            else
            {
                Console.WriteLine("不全是亚洲的人");
            }

            Console.ReadLine();
        }
    }
}

多级排序

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               orderby c.Region,c.Country,c.City // 多级排序
                               select new {c.Region , c.Country, c.City };
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

使用OrderBy，ThenBy实现

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   orderby c.Region,c.Country,c.City // 多级排序
            //                   select new {c.Region , c.Country, c.City };
            var queryResults = customers.OrderBy(c => c.Region)
                .ThenBy(c => c.Country)
                .ThenBy(c => c.City)
                .Select(c => new { c.Region,c.Country, c.City});

            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

group的使用

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;


            foreach (var item in orderedResults)
            {
                Console.WriteLine(item.TotalSales+"\t:"+item.Region);
            }

            Console.ReadLine();
        }
    }
}

通过Take方法获取前几个数据
通过Skip方法，获取剩下的数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;

            // Take获取前几个数据
            // Skip获取后几个数据
            // 出去前1个后的数据
            foreach (var item in orderedResults.Skip(1))
            {
                Console.WriteLine(item.TotalSales + "\t:" + item.Region);
            }

            Console.WriteLine("----------------------------------------");

            // 前1个
            foreach (var item in orderedResults.Take(1))
            {
                Console.WriteLine(item.TotalSales + "\t:" + item.Region);
            }


            Console.ReadLine();
        }
    }
}

First与FirstOrDefault

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;

            // 获取第一个数据,First和FirstOrDefault
            // First方法如何数据不存在，会报错
            Console.WriteLine(orderedResults.First());

            Console.WriteLine(orderedResults.FirstOrDefault());

            Console.WriteLine(orderedResults.First(c => c.Region == "Europe"));

            Console.WriteLine(orderedResults.FirstOrDefault(c => c.Region == "Europe"));
            Console.ReadLine();
        }
    }
}

JOIN使用

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }

    class Order
    {
        public string ID { get; set; }
        public decimal Amount { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            List<Order> orders = new List<Order>
            {
                new LinqDemo.Order {ID = "A",Amount = 100 },
                new LinqDemo.Order {ID = "A",Amount = 200 },
                new LinqDemo.Order {ID = "B",Amount = 300 },
                new LinqDemo.Order {ID = "B",Amount = 400 },
                new LinqDemo.Order {ID = "C",Amount = 500 },
                new LinqDemo.Order {ID = "D",Amount = 600 },
            };

            var queryResults = from c in customers
                               join o in orders on c.ID equals o.ID
                               select new { c.ID,c.City,SalesBefore = c.Sales,NewOrder = o.Amount,SalesAfter = c.Sales + o.Amount };

            foreach (var item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

本文转自TBHacker博客园博客，原文链接：http://www.cnblogs.com/jiqing9006/p/6849844.html，如需转载请自行联系原作者
文章标签：
开发工具
IDE
.NET
开发框架
桃子红了呐
目录
相关文章
aehyok
|
SQL .NET 数据库
一步一步学Linq to sql(二)：DataContext与实体
DataContext  DataContext类型（数据上下文）是System.Data.Linq命名空间下的重要类型，用于把查询句法翻译成SQL语句，以及把数据从数据库返回给调用方和把实体的修改写入数据库。
aehyok
1170 0
needrunning
|
SQL .NET C#
用LINQ在集合中查询特定对象
这里是原文出处： 简单的概括LINQ LINQ是Language-Integrated Query的缩写，是C# 3.0和VB 9.0中新加入的语言特性，可以在编程时使用内置的查询语言进行基于集合的操作。
needrunning
858 0
桃子红了呐
|
.NET 开发框架 存储
理解Linq查询
桃子红了呐
1071 0
桃子红了呐
|
机器学习/深度学习 .NET
Linq查询案例
桃子红了呐
1097 0
mcy247
|
SQL .NET 开发框架
linq to sql查询中返回linq自动建立的实体类型）
mcy247
1023 0
mcy247
|
缓存 .NET 开发框架
Linq实体类的设计（解决了复合查询的问题，同时解决了LINQ上下文缓存问题）
mcy247
1053 0
老朱教授
|
.NET 开发框架
linq 对象转换
老朱教授
1031 0
范大脚脚
|
.NET 索引 开发框架
Linq 方法表
范大脚脚
1088 0
范大脚脚
|
.NET 数据库 Windows
SQLMETAL :Linq对象生成
范大脚脚
1008 0
科技探索者
|
.NET 开发框架
Linq中两种更新操作
科技探索者
1175 0

热门文章

最新文章

  • 1
    四大触点，教你从“用户视角”构建数据分析体系
  • 2
    《Stata统计分析与应用（第2版）》一3.4 图形的保存、合并及修改
  • 3
    Spring-boot+Dubbo应用启停源码分析
  • 4
    分享一些OpenStack的qcow2格式实例镜像
  • 5
    基于区块链的机器学习模型创建方案
  • 6
    微信web开发者工具无法打开的六种解决方法
  • 7
    RocketMq-Request-Reply消息
  • 8
    [译] 构建世界上最快的会议网站
  • 9
    " "(双引号)与 ' '(单引号)的区别
  • 10
    自定义高效支持点击监听的RecyclerView
  • 1
    AI在电子商务中的个性化推荐系统：驱动用户体验升级
    32
  • 2
    基于AI的网络流量分析：构建智能化运维体系
    30
  • 3
    鸿蒙登录页面好看的样式设计-HarmonyOS应用开发实战与ArkTS代码解析【HarmonyOS 5.0（Next）】
    26
  • 4
    HarmonyOS 5.0 （Next）应用开发实战：使用ArkTS构建开箱即用的登录页面【HarmonyOS 5.0（Next）】
    32
  • 5
    开箱即用的个人主页页面开发实战—基于HarmonyOS 5.0 （Next）和ArkTS的实现【HarmonyOS 5.0（Next）】
    35
  • 6
    《Java 在 3D 视觉与重建领域：开启无限可能之旅》
    23
  • 7
    《Java 情感分析：前沿技术与方法全解析》
    28
  • 8
    《GraalVM：Java AI 应用性能与启动速度的优化利器》
    23
  • 9
    《探索 Apache Spark MLlib 与 Java 结合的卓越之道》
    20
  • 10
    云产品评测
    23

    • 相关电子书

    更多
  • 低代码开发师（初级）实战教程
  • 冬季实战营第三期：MySQL数据库进阶实战
  • 阿里巴巴DevOps 最佳实践手册
    • 下一篇
    【案例实战】SpringBoot整合阿里云文件上传OSS