LINQ in Action - THE LINQ book

I recently posted some code that allows you to use LINQ to query Excel tables.  The source for these queries is the Open XML document – you don’t need to involve the Excel application to query the data in these tables.  In that post, I presented a few examples of queries of various types.  This post shows a join of two ...

[Blog Map] Excel has a very cool feature where you can declare that a range of cells is a table.  It is a feature that allows you to use Excel very much like a database.  You can add new rows as necessary, sort the table by columns, do some simple filtering, calculate the sum of columns, and more.  Each table has a unique table ...

I’ll be presenting two sessions on the Open XML SDK at Tech Ed 2008 EMEA in Barcelona. OFC206 - Open XML SDK Version 2 Overview and Architecture (November 12, 13:30 - 14:45) In this session, I’ll present an overview of V2 of the Open XML SDK.  I’ll talk a bit about the architecture of the Open XML formats.  I’ll then compare and ...

[Blog Map]  Anders Hejlsberg presented a fascinating and entertaining session at PDC 2008 on C# 4.0.  He talked about dynamic typing, optional and named parameters, improved COM interoperability, and improved support for co-variance and contra-variance.  These language improvements are very cool – they enable us to write code that ...

You can build very powerful document assembly solutions using the Open XML SDK V2 literally in just a few minutes.  In our presentation at PDC 2008, amongst other demos, Zeyad Rajabi and I will demonstrate this in a live coding session.  We'll be using the LINQ friendly features of the SDK.  It really is a quite a remarkable set of ...

When I was writing the LINQ to XML documentation, Ralf Lämmel was the program manager for LINQ to XSD, an incubation project in the data programmability group at Microsoft.  Ralf really helped me a lot in those days, both with questions on LINQ to XML, and questions around functional programming.  It was in email exchanges ...