C# Linq 左外联
2021/9/26 14:10:54
本文主要是介绍C# Linq 左外联,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
C# Linq 左外联
假设我们有一个Student类,具有姓名、年龄、班级Id三个属性
还有一个Class类,具有Id,班级名两个属性
现要查找学生姓名、年龄和其所在班级名,因此需要做一个Student表左联Class表的操作
方式一:
var results = from s in students join c in classes on s.ClassId equals c.Id into scs from sc in scs.DefaultIfEmpty() select new { Name = s.Name, Age = s.Age, ClassName = sc?.ClassName ?? string.Empty };
方式二:
var results = students.GroupJoin(classes, s => s.ClassId, c => c.Id, (s, cs) => new { Name = s.Name, Age = s.Age, ClassName = cs.ElementAtOrDefault(0) is null ? string.Empty : cs.ElementAt(0).ClassName });
完整代码演示:
using System; using System.Collections.Generic; using System.Linq; public class Student { public string Name { get; set; } public int Age { get; set; } public int ClassId { get; set; } } public class Class { public int Id { get; set; } public string ClassName { get; set; } } public class Program { public static void Main() { List<Student> students = new List<Student>() { new Student(){Name = "B", Age = 18, ClassId = 1}, new Student(){Name = "C", Age = 19, ClassId = 2}, new Student(){Name = "A", Age = 20, ClassId = 3}, new Student(){Name = "D", Age = 20, ClassId = 4}, new Student(){Name = "E", Age = 20, ClassId = 5}, }; List<Class> classes = new List<Class>() { new Class(){ Id = 1, ClassName = "1班"}, new Class(){ Id = 2, ClassName = "2班"}, new Class(){ Id = 3, ClassName = "3班"}, }; //方式一: //var results = from s in students // join c in classes on s.ClassId equals c.Id into scs // from sc in scs.DefaultIfEmpty() // select new { Name = s.Name, Age = s.Age, ClassName = sc?.ClassName ?? string.Empty }; //方式二: var results = students.GroupJoin(classes, s => s.ClassId, c => c.Id, (s, cs) => new { Name = s.Name, Age = s.Age, ClassName = cs.ElementAtOrDefault(0) is null ? string.Empty : cs.ElementAt(0).ClassName }); foreach (var result in results) { Console.WriteLine($"{result.Name} {result.Age} {result.ClassName}"); } } }
这篇关于C# Linq 左外联的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2022-03-01沐雪多租宝商城源码从.NetCore3.1升级到.Net6的步骤
- 2024-05-08首个适配Visual Studio平台的国产智能编程助手CodeGeeX正式上线!C#程序员必备效率神器!
- 2024-03-30C#设计模式之十六迭代器模式(Iterator Pattern)【行为型】
- 2024-03-29c# datetime tryparse
- 2024-02-21list find index c#
- 2024-01-24convert toint32 c#
- 2024-01-24Advanced .Net Debugging 1:你必须知道的调试工具
- 2024-01-24.NET集成IdGenerator生成分布式全局唯一ID
- 2024-01-23用CI/CD工具Vela部署Elasticsearch + C# 如何使用
- 2024-01-23.NET开源的简单、快速、强大的前后端分离后台权限管理系统