Merge column in Datable & calculate value (LINQ)

This is a myth. For Each is not slower. In fact, LINQ can be slower because it introduces additional overhead. Also, LINQ does not avoid looping. It has to loop just like anything else. It just makes it hidden.