>>Could somebody translate
>>
>>

>>select Kl_Nummer,ArtBtw,sum(bestd_waarde) as netto from [somtable] group by kl_nummer,ArtBtw
>>

>>
>>into linq?
>>
>>Thanks. Just need to see it done once, or refer me to a link (no pun intended)
>
>Brain not up to that at the moment (if ever :-} ) but you could plough through this :
>http://msdn.microsoft.com/en-us/vcsharp/aa336746

Yeah .... seen that before. Must be crystal clear for anybody with 150 years experience in Linq.

just want to generate a table with the total of one field grouped by another field.

select field1, sum(field2) as total from mytable group by field1.

Should not be rocket science.