1、本篇我来记录一下我学习的SelectMany的几种重载方法
2、在Linq中,SelectMany这个方法理解起来其实还是稍微有点绕的
3、我是通过观看视频学习和看别人发的笔记学习到的,接下来分享给大家
一、首先我们先建立两个实体,大家可以通过数据库传值。
我这里用的是控制器项目,比较简便给大家演示
第一个实体,新建一个类:
public class Person
{
//姓名
public string Name { get; set; }
//性别
public string Gender { get; set; }
//年龄
public int Age { get; set; }
//课程表
public List<ClassScheduleCard> Phones { get; set; }
}
第二个实体,新建一个类:
public class ClassScheduleCard
{
//课程
public string Curriculum { get; set; }
//老师
public string Teacher { get; set; }
//学校
public string School { get; set; }
}
二、新建好我们的实体后我们就要开始进行调用
如果你是用的数据库字段,那么就不用生成死的集合。这里我没有新建数据库,所以我就调用的我新生成的集合如下
#region 创建集合
List<Person> PersonLists = new List<Person>()
{
new Person { Name = "唱跳Rap",Age = 20,Gender = "男",
Phones = new List<ClassScheduleCard> {
new ClassScheduleCard { School = "安阳第五小学", Teacher = "小白", Curriculum = "英语" },
new ClassScheduleCard { School = "安阳第五小学",Teacher = "小黑",Curriculum = "英语"},
new ClassScheduleCard { School = "安阳第五小学",Teacher = "小白",Curriculum = "语文"},
new ClassScheduleCard { School = "安阳第五小学",Teacher = "小黄",Curriculum = "数学"},
}
},
new Person { Name = "及你太美",Age = 30,Gender = "男",
Phones = new List<ClassScheduleCard> {
new ClassScheduleCard { School = "郑州第一中学",Teacher = "小黄",Curriculum = "政治"},
new ClassScheduleCard { School = "郑州第二中学",Teacher = "大黄",Curriculum = "语文"},
new ClassScheduleCard { School = "郑州第三中学",Teacher = "小黑",Curriculum = "科学"},
}
},
new Person { Name = "小黑子",Age = 40,Gender = "男",
Phones = new List<ClassScheduleCard> {
new ClassScheduleCard { School = "苏州大学",Teacher = "小紫",Curriculum = "计算机"},
new ClassScheduleCard { School = "郑州大学",Teacher = "小绿",Curriculum = "毛概"},
new ClassScheduleCard { School = "河南大学",Teacher = "小der",Curriculum = "C语言"}
}
}
};
#endregion
有了数据之后,我们就可以进行数据的查询调用接下来就开始实现SelectMany的方法重载
第一种重载方式:
Console.WriteLine("****************************************************************");
Console.WriteLine("SelectMany第一种重载查询结果");
var lists_1 = PersonLists.SelectMany(p => p.Phones);
foreach (var list in lists_1)
{
Console.WriteLine($"{list.School} -- {list.Teacher} -- {list.Curriculum}");
}
运行结果是这样的:
第二种重载方式:
//第二种重载方式
Console.WriteLine("****************************************************************");
Console.WriteLine("SelectMany第二种重载查询结果");
var lists_2 = PersonLists.SelectMany((p, i) =>
{
p.Phones.ForEach(q => q.School += i.ToString());
return p.Phones;
});
foreach (var list in lists_2)
{
Console.WriteLine($"{list.School} -- {list.Teacher} -- {list.Curriculum}");
}
第二种重载结果是这样的:
第三种重载方式:
Console.WriteLine("****************************************************************");
Console.WriteLine("SelectMany第三种重载查询结果");
var lists_3 = PersonLists.SelectMany(p => p.Phones, (p, q) => new { PersonCurriculum = p.Name, PhoneCurriculum = q.Curriculum });
foreach (var list in lists_3)
{
Console.WriteLine($"{list.PersonCurriculum} -- {list.PhoneCurriculum}");
}
第三种重载结果是这样的:
第四种重载方式:
Console.WriteLine("****************************************************************");
Console.WriteLine("SelectMany第四种重载查询结果");
var lists_4 = PersonLists.SelectMany((p, i) =>
{
p.Phones.ForEach(q => q.Curriculum += i.ToString());
return p.Phones;
},
(q,p) => new {PersonCurriculum = p.Curriculum,PhoneCurriculum =q.Name});
foreach (var list in lists_4)
{
Console.WriteLine($"{list.PersonCurriculum} -- {list.PhoneCurriculum}");
}
第四种重载结果是这样的:
通过以上几种方法可以看出,其实用法都是差不多的,有的只是多了一点数据和统计。SelectManhy的用法远远不止这么简单,还有很多复杂的用法,大家可以多琢磨琢磨,有更深入的了解,记得给我也分享分享🤭🤭🤭🤭