如何从LINQ查询表中的多行获得最佳性能

my goal is to get lots of rows from a translation table. I use an ID to get a subset of the table (say 50 rows) then I use another ID to the rows I want from this subset. Using typed datasets I do the following to get the main dataset: my goal is to get lots of rows from a translati