登录
当前位置： 首页 > 工具软件 > LINQ > 使用案例 >

C#中的LINQ

冯元徽
2023-12-01

一：什么是LINQ

LINQ代表语言集成查询，是.net框架的扩展，它允许我们用SQL查询数据库的方式来查询数据的集合

二：LINQ延迟查询的特性

延迟查询是指查询操作并不是在定义的时候执行，而是在遍历集合中的数据时才执行
因为作为yield迭代器的主体，只有使用foreach遍历执行到MoveNext时才会真正执行方法

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Where((p) => p.Age < 30);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }

        personList.Add(new Person() { Id = 4, Name = "小赵", Age = 15, Score = 100 });

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

三：扩展方法用法

Linq有两种写法，查询表达式写法(from.....in.....)和扩展方法写法，两种方法都是相互兼容的，程序编译时会将查询表达式转换为扩展方法，只要实现了IEnumerable的接口就可以使用Linq的扩展方法

——Select：返回指定类型

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Select(p => p.Name);
        var list = personList.Select(p => new { id = p.Id, name = p.Name });

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Where：查询特定条件

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Where((p) => p.Score >= 80 && p.Age < 50);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——OfType：查询特定数据类型 

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<object> objList = new List<object>()
    {
        "test1",
        1,
        1.34f,
        "test2",
    };

    static void Main(string[] args)
    {
        var list = objList.OfType<string>();

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

——Join：将一个集合与另一个集合通过指定键合并，返回合并后的集合

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };
    static List<Reward> rewardList = new List<Reward>()
    {
        new Reward(){ Id=1,Score=100,RewardName="奖励1"},
        new Reward(){ Id=2,Score=80,RewardName="奖励2"},
        new Reward(){ Id=3,Score=60,RewardName="奖励3"},
    };

    static void Main(string[] args)
    {
        var list = personList.Join(rewardList, p => p.Score, r => r.Score, (p, r) => new { pList = p, rList = r });

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

class Reward
{
    public int Id;
    public int Score;
    public string RewardName;

    public override string ToString()
    {
        return Id + "," + Score + "," + RewardName;
    }
}

——GroupJoin： 将一个集合与另一个集合通过指定键分组

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };
    static List<Reward> rewardList = new List<Reward>()
    {
        new Reward(){ Id=1,Score=101,RewardName="奖励1"},
        new Reward(){ Id=2,Score=80,RewardName="奖励2"},
        new Reward(){ Id=3,Score=60,RewardName="奖励3"},
    };

    static void Main(string[] args)
    {
        var list = personList.GroupJoin(rewardList, p => p.Score, r => r.Score, (p, result) => new { pList = p, count = result.Count() });

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

class Reward
{
    public int Id;
    public int Score;
    public string RewardName;

    public override string ToString()
    {
        return Id + "," + RewardName;
    }
}

——OrderBy：对集合排序，默认是从小到大排序

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=60,Score=60},
        new Person(){ Id=3,Name="小刘",Age=60,Score=80},
    };

    static void Main(string[] args)
    {
        var list = personList.OrderBy((p) => p.Age).ThenBy((p) => p.Score);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Reverse：反转集合中元素的顺序

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.AsEnumerable().Reverse();

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

——GroupBy：自身分组查询

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
        new Person(){ Id=4,Name="小赵",Age=30,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.GroupBy((p) => p.Score, (score, p) => new { score = score, count = p.Count() });

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Any和All：判断集合中是否满足某个/条件

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        bool b1 = personList.Any((p) => p.Age < 50);
        bool b2 = personList.All((p) => p.Age < 50);

        Console.WriteLine(b1);
        Console.WriteLine(b2);
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Skip：跳过指定个元素查询

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Skip(1);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Take：只查询指定个元素

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Take(2);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Sum、Average、Max、Min：计算集合中指定数字类型数据的总和、平均值、最大值、最小值

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var sum = personList.Sum((p) => p.Age);
        var avg = personList.Average((p) => p.Age);
        var max = personList.Max((p) => p.Age);
        var min = personList.Min((p) => p.Age);

        Console.WriteLine(sum);
        Console.WriteLine(avg);
        Console.WriteLine(max);
        Console.WriteLine(min);
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——Concat： 连接两个相同类型集合，合并为一个集合

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<int> numList1 = new List<int>() { 1, 2, 3 };
    static List<int> numList2= new List<int>() { 4, 5, 6 };

    static void Main(string[] args)
    {
        var list = numList1.Concat(numList2);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

——Distinct：从集合中去除掉重复的元素

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<int> numList = new List<int>() { 1, 2, 3, 1, 2, 3 };

    static void Main(string[] args)
    {
        var list = numList.Distinct();

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

使用Distinct去重类中某个字段需要实现IEqualityComparer接口

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.Distinct(new Person());

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person : IEqualityComparer<Person>
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public new bool Equals(Person x, Person y)
    {
        if (x == null || y == null)
        {
            return false;
        }
        if (x.Age == y.Age)
        {
            return true;
        }
        return false;
    }

    public int GetHashCode(Person obj)
    {
        return obj.Age.GetHashCode();
    }

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——ElementAt：得到集合中指定索引的元素，与[]作用相同

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<int> numList = new List<int>() { 1, 2, 3};

    static void Main(string[] args)
    {
        var value = numList.ElementAt(2);

        Console.WriteLine(value);
    }
}

 ——Count：得到集合中满足指定条件的元素个数

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<int> numList1 = new List<int>() { 1, 2, 3 };

    static void Main(string[] args)
    {
        var count = numList1.Count((n) => n >= 2);

        Console.WriteLine(count);
    }
}

——First/Single和Last：得到集合中第一个/最后一个元素(如果集合中包含多个元素，使用Single会报错)

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<int> numList1 = new List<int>() { 1, 2, 3 };

    static void Main(string[] args)
    {
        var value1 = numList1.First((n) => n >= 2);
        var value2 = numList1.Last((n) => n < 3);

        Console.WriteLine(value1);
        Console.WriteLine(value2);
    }
}

——ToDictionary：将集合转换为字典 

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var list = personList.ToDictionary(p => p.Id);

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}

——ToList： 将集合转换为list

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static List<Person> personList = new List<Person>()
    {
        new Person(){ Id=1,Name="小明",Age=20,Score=100},
        new Person(){ Id=2,Name="小王",Age=40,Score=80},
        new Person(){ Id=3,Name="小刘",Age=60,Score=60},
    };

    static void Main(string[] args)
    {
        var dict = personList.ToDictionary(p => p.Id);
        List<Person> list = dict.Values.ToList();

        foreach (var temp in list)
        {
            Console.WriteLine(temp);
        }
    }
}

class Person
{
    public int Id;
    public string Name;
    public int Age;
    public int Score;

    public override string ToString()
    {
        return Id + "," + Name + "," + Age + "," + Score;
    }
}


——SequenceEqual：判断两个集合是否相等

using System;
using System.Collections.Generic;
using System.Linq;

class MainClass
{
    static void Main(string[] args)
    {
        List<int> list1 = new List<int>() { 1, 2, 3 };
        List<int> list2 = new List<int>() { 3, 1, 2 };
        list1 = list1.OrderBy(temp => temp).ToList();
        list2 = list2.OrderBy(temp => temp).ToList();

        Console.WriteLine(list1.SequenceEqual(list2));
    }
}

 

 类似资料：

相关阅读

C / C ++中的mbsrtowcs()函数C / C ++中的putwchar()函数C / C ++中的rand()和srand()C#中的GetLogicalDrivesC#中的Environment.NewLine

相关文章

中望C++笔试中望c++一面中望一面 C++C语言中的文件是什么？C语言中的整数（short,int,long）

相关问答

C中的QSORT函数c中的“运算符Swift中的C结构限制C中的FPSC/C中的固定长度数据类型

相关文档

Effective C++ 中文版C# 中文指南C++ 中文教程Boost C++ 中文文档Effective Modern C++ 中文版
快捷导航： 新手教程 算法原理 架构设计 Java进阶 数据库进阶 大厂专栏 面试经验 编程笔记 编程问答 所有专题 文档资料 工具软件 电子书籍 小牛导航
在线工具： 房贷计算器 个税计算器 Linux命令查询 Json格式化 正则表达式 颜色转换 AES加解密 SHA1加密 MD5加密 毒鸡汤 字数统计 随机密码生成 进制转换 Base64编解码 励志句子
Copyright © 2019-2024 小牛知识库@xnip.cn. All Rights Reserved.