>>But the SQL examples you give can't be used against DataTables anyway.
>
>I do use it against datatables and it seems to work for me. I guess the IEnumerable is somehow implicit.

You use this?:

select sight, sum(ValueBox) as totalValueBox ... from (oDT) group by sight.

>
>> Without linq all you would have is DataTable.Select to get a subset of rows or DataTable.Compute to sum things.
>
>And you also have datable.copy().sort I have found.
>
>All in all it's about the same functionality we used to have in DAO/ADO recordset, together with move and other.
>
>>
>>Admittedly Linq to DataSet is one of the more complicated usages of Linq - but general linq usage is the same whether for this, objects, xml etc. And don't forget that a query expression can be built up over several statements for clarity.
>
>Well good to know that not everybody runs when they see a LINQ statement. As I said earlier, when I grow up I wanna be a LINQ programmer.
>
>Thanks and take care.