I must confess I started educating myself about LINQ pretty late. I was really pleased to see what all it can do. I discovered that all typed Datasets allowed LINQ based querying.
This means old methods of working with Datable object should be forgotten and LINQ should be used where ever possible. Time to get rid of all those ugly 'foreach' blocks .
Read my article on using LINQ and typed datasets here: