C #: Iterating over a data table: rows, Select () or AsEnumerable ()

Question

foreach (DataRow row in myDataTable.Select()) foreach (DataRow row in myDataTable.AsEnumerable()) foreach (DataRow row in myDataTable.Rows) 

Any differences?

Answer 1

Rows not strongly typed - so a cast will be performed at each iteration, and you cannot easily use LINQ for objects. (I believe that AsEnumerable() should also use every iteration within itself, but at least you can easily use it for other LINQ methods.)

Select should build an array, so there obviously is a performance limitation there.

Personally, I would use AsEnumerable() if you don't want to modify the table in a loop, in which case the fact that Select building the array up can be an advantage.

Answer 2

Use AsEnumerable () if you are trying to query data using LINQ, otherwise you could use a loop structure ...