C#_LINQ数据查询

最新推荐文章于 2024-03-05 20:23:03 发布

小可_子衿

最新推荐文章于 2024-03-05 20:23:03 发布

阅读量587

点赞数

分类专栏： C# 文章标签： C# LINQ 数据查询

本文链接：https://blog.csdn.net/c201038795050/article/details/50382775

版权

C# 专栏收录该内容

36 篇文章 1 订阅

订阅专栏

using System;
using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;

namespace CShapeTest
{
    class Master
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
        public string Kungfu { get; set; }
        public int Level { get; set; }

        public override string ToString()
        {
            return string.Format("Id:{0}, Name:{1}, Age:{2}, Kungfu:{3}, Level:{4}", Id, Name, Age, Kungfu, Level);
        }
    }

    class Kungfu
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public int Power { get; set; }

        public override string ToString()
        {
            return string.Format("Id:{0}, Name:{1}, Power:{2}", Id, Name, Power);
        }
    }

    class Start
    {
        static void Main(string[] args)
        {
            List<Master> masterList = new List<Master>();
            masterList.Add(new Master() { Id = 1, Name = "东风不败", Age = 35, Kungfu = "葵花宝典", Level = 10});
            masterList.Add(new Master() { Id = 2, Name = "林平之", Age = 23, Kungfu = "葵花宝典", Level = 7 });
            masterList.Add(new Master() { Id = 3, Name = "岳不群", Age = 50, Kungfu = "葵花宝典", Level = 8 });
            masterList.Add(new Master() { Id = 4, Name = "令狐冲", Age = 23, Kungfu = "孤独九剑", Level = 10 });
            masterList.Add(new Master() { Id = 5, Name = "梅超风", Age = 35, Kungfu = "九阴真经", Level = 8 });
            masterList.Add(new Master() { Id = 6, Name = "黄药师", Age = 50, Kungfu = "弹指神通", Level = 10 });
            masterList.Add(new Master() { Id = 7, Name = "风清扬", Age = 50, Kungfu = "孤独九剑", Level = 10 });

            List<Kungfu> kungfuList = new List<Kungfu>();
            kungfuList.Add(new Kungfu() { Id = 1, Name = "打狗棒法", Power = 90});
            kungfuList.Add(new Kungfu() { Id = 2, Name = "降龙十八掌", Power = 95 });
            kungfuList.Add(new Kungfu() { Id = 3, Name = "葵花宝典", Power = 100 });
            kungfuList.Add(new Kungfu() { Id = 4, Name = "孤独九剑", Power = 100 });
            kungfuList.Add(new Kungfu() { Id = 5, Name = "九阴真经", Power = 100 });
            kungfuList.Add(new Kungfu() { Id = 6, Name = "弹指神通", Power = 100 });

            // 查询武功等级大于8的大师

            // 使用foreach查询
            //List<Master> resList = new List<Master>();
            //foreach (var item in masterList)
            //{
            //    if (item.Level > 8)
            //    {
            //        resList.Add(item);
            //    }
            //}

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

            // 使用LINQ单一查询(表达式写法)
            //var resList = from m in masterList where m.Level > 8 && m.Age > 23 select m;
            //foreach (var item in resList)
            //{
            //    Console.WriteLine(item);
            //}

            // 使用LINQ单一查询(扩展方法写法)
            //var resList = masterList.Where((Master m) =>
            //{
            //    if (m.Level > 8 && m.Age > 23)
            //    {
            //        return true;
            //    }
            //    else
            //    {
            //        return false;
            //    }
            //});
            //foreach (var item in resList)
            //{
            //    Console.WriteLine(item);
            //}

            // 查询武功杀伤力大于90，并且年龄小于30的大师

            // 使用LINQ联合查询(表达式写法)
            //var resList = from m in masterList from k in kungfuList where m.Kungfu == k.Name && m.Age < 30 && k.Power > 90 select m;
            //foreach (var item in resList)
            //{
            //    Console.WriteLine(item);
            //}

            // 使用LINQ联合查询(扩展方法写法)
            //var resList = masterList.SelectMany((Master m) => kungfuList, (Master m, Kungfu k) => new {master = m, kungfu = k}).Where((x) => x.master.Kungfu == x.kungfu.Name && x.master.Age < 30 && x.kungfu.Power > 90);
            //foreach (var item in resList)
            //{
            //    Console.WriteLine(item);
            //}

             使用LINQ单一查询的同时，进行排序(表达式写法)
            //var resList = from m in masterList where m.Level > 8 orderby m.Age,m.Level select m;
            //foreach (var item in resList)
            //{
            //    Console.WriteLine(item);
            //}

            // 使用LINQ单一查询的同时，进行排序(扩展方法写法)
            var resList = masterList.Where(m => m.Level > 8).OrderBy(m => m.Age).ThenBy(m => m.Level);
            foreach (var item in resList)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}