LinqToEntities:Union IEqualityComparer

最新推荐文章于 2020-03-14 11:02:05 发布

weixin_30359021

最新推荐文章于 2020-03-14 11:02:05 发布

阅读量84

点赞数

原文链接：http://www.cnblogs.com/yangfan/archive/2010/04/26/1720981.html

版权

转自：http://stackoverflow.com/questions/2296966/linq-to-entities-unions-distinct

Q：

I don't know how I can do several union with a distinct.

When I use .Distinct with an IEqualityComparer an exception in threw :

LINQ to Entities does not recognize the method 'System.Linq.IQueryable'

My code is

  = query.(query1).(query2); 
 = .( ());

A：

LINQ to Entities does not support the overload of Distinct which takes an IEqualityComparer. When you think about it, it really can't, because LINQ to Entities queries will be converted to SQL, and you cannot convert an interface reference to SQL.

Therefore, you must either:

  the overload of  which does  take any compare,  
   both lists   space   the   LINQ to , like : 
 
  = query.(query1).(query2); 
 = .().( ());

Naturally, the risk here is that you might bring too many records back from the DB server. You could also use both of these techniques in order to do a portion of the comparison on the server and another portion in object space.

转载于:https://www.cnblogs.com/yangfan/archive/2010/04/26/1720981.html