linq vs. dataSet?

[Andy B]

Is it more practicle to use linq instead of a dataSet for sql access? It
seems like it would take up less resources and less code. Any ideas on this
subject?

 

[Marc Gravell]

I would; you get the benefit of composable queries (i.e. your filters,
sorts, paging etc can be passed all the way to the database to
minimise data throughput), and the advantages of working with a more
typical class model.

Marc