Code: Select all
var list = context.Entities.Select(p => p.ClobProperty).Distinct().ToList();
Code: Select all
var list = context.Entities.Union(context.Entities).ToList();
Code: Select all
var list = context.Entities.Select(p => p.ClobProperty).Distinct().ToList();
Code: Select all
var list = context.Entities.Union(context.Entities).ToList();
Code: Select all
var list = context.Entities.Select(p => p.ClobProperty.Substring(0, 4000)).Distinct().ToList();
We would be very much obliged to you, if you share your solution. Probably, we will provide you with an alternative way (with LINQ) or your solution will be useful to other users.I found a raw sql solution, where to first execute a UNION ALL and continue with DINSTINC over a hash of clob column. Unfortunally I see no way to implement that with LINQ.