Check if specific value form dt1 exist in dt2

[ppr (Peter Preuss)]

@rikulsilva

Count return = 0.

Let us mention this recommendation as well:

CA1827: Do not use Count/LongCount when Any can be used (code analysis) - .NET

So we rewrite to any with predicate
…Any(Function (x) …)
Or
…Where(Function (x)…).Any()

In case of another optimization is needed also have a look here:

LINQ query running for long hours

Let us introduce the next changes [grafik] we are creating lists with the concatenated strings from dtold, dtnew and creating a dictionary of only the items common in both lists dtNewSet.asEnumerable.Select(Function (x) String.Join(“#”, arrColSet.Select(Function (k) x(k).toString.ToLower.Trim))).Distinct().toList dtOldSet.asEnumerable.Select(Function (x) String.Join(“#”, arrColSet.Select(Function (k) x(k).toString.ToLower.Trim))).Distinct().toList ListDT1.Intersect(ListDT2).ToDictionary(Fun…

we took benefits from lists/dictionary keys