完美解决c# distinct不好用的问题
作者:萌橙 时间:2023-02-13 11:22:53
当一个结合中想根据某一个字段做去重方法时使用以下代码
IQueryable 继承自IEnumerable
先举例:
#region linq to object
List<People> peopleList = new List<People>();
peopleList.Add(new People { UserName = "zzl", Email = "1" });
peopleList.Add(new People { UserName = "zzl", Email = "1" });
peopleList.Add(new People { UserName = "lr", Email = "2" });
peopleList.Add(new People { UserName = "lr", Email = "2" });
Console.WriteLine("用扩展方法可以过滤某个字段,然后把当前实体输出");
peopleList.DistinctBy(i => new { i.UserName }).ToList().ForEach(i => Console.WriteLine(i.UserName + i.Email));
Console.WriteLine("默认方法,集合中有多个字段,当所有字段发生重复时,distinct生效,这与SQLSERVER相同");
peopleList.Select(i => new { UserName = i.UserName, Email = i.Email }).OrderByDescending(k => k.Email).Distinct().ToList().ForEach(i => Console.WriteLine(i.UserName + i.Email));
Console.WriteLine("集合中有一个字段,将这个字段重复的过滤,并输出这个字段");
peopleList.Select(i => new { i.UserName }).Distinct().ToList().ForEach(i => Console.WriteLine(i.UserName));
#endregion
该扩展方法贴出:
public static class EnumerableExtensions
{
public static IEnumerable<TSource> DistinctBy<TSource, Tkey>(this IEnumerable<TSource> source, Func<TSource, Tkey> keySelector)
{
HashSet<Tkey> hashSet = new HashSet<Tkey>();
foreach (TSource item in source)
{
if (hashSet.Add(keySelector(item)))
{
yield return item;
}
}
}
}
补充知识:c# – .Distinct()调用不过滤
我正在尝试使用AsEnumerable将Entity Framework DbContext查询拉入IEnumerable< SelectListItem>.这将用作填充视图中下拉列表的模型属性.
但是,尽管调用了Distinct(),但每个查询都会返回重复的条目.
public IEnumerable<SelectListItem> StateCodeList { get; set; }
public IEnumerable<SelectListItem> DivCodeList { get; set; }
DivCodeList =
db.MarketingLookup.AsEnumerable().OrderBy(x => x.Division).Distinct().Select(x => new SelectListItem
{
Text = x.Division,
Value = x.Division
}).ToList();
StateCodeList =
db.MarketingLookup.AsEnumerable().OrderBy(x => x.State).Distinct().Select(x => new SelectListItem
{
Text = x.State,
Value = x.State
}).ToList();
为了使Distinct生效,如果类型是自定义类型,则序列必须包含实现IEquatable接口的类型的对象.
正如here所述:
Distinct returns distinct elements from a sequence by using the
default equality comparer to compare values.
一个解决方法,为了避免上述情况,因为我可以得出结论,你不需要整个对象而不是它的一个属性,就是将序列的每个元素投影到Division,然后创建OrderBy并调用Distinct :
var divisions = db.MarketingLookup.AsEnumerable()
.Select(ml=>ml.Division)
.OrderBy(division=>division)
.Distinct()
.Select(division => new SelectListItem
{
Text = division,
Value = division
}).ToList();
有关此问题的进一步文档,请查看here.
来源:https://www.cnblogs.com/daimaxuejia/p/10971869.html
标签:c#,distinct
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Java日期时间类(Date、DateFormat、Calendar)解析
2022-08-06 18:02:14
Android中Root权限获取的简单代码
2021-10-22 20:42:52
Json读写本地文件实现代码
2023-10-10 06:03:21
Java 8 Stream 的终极技巧——Collectors 功能与操作方法详解
2023-02-01 16:23:30
Docker 存储驱动详细介绍
2023-12-21 03:18:34
![](https://img.aspxhome.com/file/2023/1/83431_0s.png)
浅谈Java中实现深拷贝的两种方式—clone() & Serialized
2022-04-05 18:36:15
SpringCloud 客户端Ribbon负载均衡的实现方法
2023-03-22 16:42:43
![](https://img.aspxhome.com/file/2023/6/118886_0s.png)
如何使用Android注解处理器
2023-08-16 16:49:05
![](https://img.aspxhome.com/file/2023/8/139418_0s.jpg)
Java全面分析面向对象之继承
2023-11-23 11:55:59
![](https://img.aspxhome.com/file/2023/5/59735_0s.png)
C#使用Aspose.Cells创建和读取Excel文件
2022-11-24 17:47:23
![](https://img.aspxhome.com/file/2023/2/75592_0s.jpg)
IntelliJ IDEA 常用设置(配置)吐血整理(首次安装必需)
2021-06-24 15:23:49
![](https://img.aspxhome.com/file/2023/8/84278_0s.png)
Android Room数据库多表查询的使用实例
2022-11-07 02:49:49
![](https://img.aspxhome.com/file/2023/4/114314_0s.jpg)
IDEA全量替换一次性解决旧项目并将所有文件换行符改为LF问题
2022-09-17 18:44:32
![](https://img.aspxhome.com/file/2023/7/71927_0s.png)
ibatis学习之搭建Java项目
2021-11-02 00:35:29
Android集成微信登录的步骤详解
2023-01-12 15:12:45
![](https://img.aspxhome.com/file/2023/2/125392_0s.png)
spring scheduled单线程和多线程使用过程中的大坑
2022-09-24 05:51:10
Android获取apk签名指纹的md5值(防止重新被打包)的实现方法
2023-06-23 04:26:12
探讨如何用委托处理排序
2023-12-17 15:06:36
Java中两个List之间的比较方法(差集、交集和并集)
2023-03-06 06:34:42
SpringBoot访问windows共享文件的方法
2023-11-08 13:37:13