LINQ to DataSets – the Missing Manual


Last week I had to prepare a small presentation for a new LINQ workshop. For my research, I browsed through the MSDN documentation on LINQ where I came across a reference to "LINQ to DataSets". I couldn’t find any more information about it though, and so LINQ to DataSets got a small mention in my presentation, but I couldn’t say anything more about it.

This morning I discovered that Fabrice Marguerie and his co-authors have published a bonus 47-page chapter of their book "LINQ in Action", all about this very subject. The chapter is called "Working with LINQ and DataSets", and they have made a PDF version available online for FREE download from the Manning Press website.

You can go get it right now.

Thanks Fabrice, for filling in the missing gap.

I’m going back to update my presentation…

  • Nice chapter! Now I am just wondering how LINQ actually queries the DataSet. Is the expression tree translated into something that will use the same mechanics as e.g. a DataView’s filter? Are there any performance differences in querying via DatView or via LINQ, or is it all the same…

  • You’re welcome :-)

    It looks like you can’t link directly to the PDF. The link to the PDF can be found directly on the book homepage: http://www.manning.com/marguerie/

    Thanks

  • Frank, Linq to Datasets just uses LINQ to Objects to query them in memory datasets. You may find better performance with a dataView in some cases. LINQ to Datasets gives you additional functionality in terms of complexity, joins, aggregation, set operations that you don’t get otherwise with the standard dataset implementations.

You can follow any responses to this entry through the RSS 2.0 feed.