Without even knowing anything specific about the implementation of  
Select(), I cannot imagine that there's a significant difference between  
the two approaches when the table has only ten rows at most.

That said, this is something that should be easy enough for you to verify  
yourself.  Even without formal profiling tools, just use the Stopwatch  
class to measure the time each implementation takes and compare the two  
directly that way.

By the way, the "if (dr.Length > 0)" is pointless.  The for() loop will do  
that check implicitly, since 0 (the initial value of i) is not less than 0.

Also, foreach() and Select() are not mutually exclusive.  Even if there  
was some performance advantage to using Select(), you could still  
enumerate the results with foreach() rather than using an explicit loop  
variable.  IMHO, using foreach() is preferable when it's an option.

Pete

For sure is the select slower, the select uses an expression which has first
to be translated.

The enumurating through the property rows is for sure as fast as the doing
the same through the collection of rows (although it are probably less
rows). As Peter already wrote, you have to investigate the result of the
select first because it can return null. And then you loose even more time.

We are talking probably about thousands of picoseconds

Cor