LINQ in Action - THE LINQ book

Browse by Tags

• Dynamic Types
• LINQ
• LINQ to XML
• OpenXmlSdk
• PDC2008
• PowerTools
• TechEd2008
• Useful Code Snippets
• xml

• Inner Join of Two Excel Tables

  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 tables using the extension methods and classes presented in that post. The source for this query is a spreadsheet where I imported two columns of the Northwind data into two worksheets. Read More... Posted Thursday, November 20, 2008 6:14 AM from Eric White's Blog | (Comments Off) Filed under: LINQ, OpenXML, LINQ to XML, OpenXmlSdk, Functional Programming

• Using LINQ to Query Excel Tables

  [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 name, and each column has a name unique to its table. Because these tables are stored in Open XML documents, we can implement some simple extension methods and some classes so Read More... Posted Friday, November 14, 2008 6:54 AM from Eric White's Blog | (Comments Off) Filed under: LINQ, OpenXML, LINQ to XML, OpenXmlSdk, Useful Code Snippets, Functional Programming

• Open XML SDK at TechEd EMEA Developers

  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 contrast the Office object model and the Open XML SDK, and the key benefits from using the SDK. We’ll discuss the architecture of the Open XML SDK, and the roadmap for the Read More... Posted Thursday, October 30, 2008 9:59 PM from Eric White's Blog | (Comments Off) Filed under: LINQ, OpenXML, LINQ to XML, OpenXmlSdk, Functional Programming, TechEd2008

• Anders Hejlsberg Introduces C# 4.0 at PDC 2008

  [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 more closely expresses our intent, with less syntactic noise. Carve out some time, and watch his PDC session . Anders is a dynamic presenter, so you won’t be bored! Dynamic Read More... Posted Wednesday, October 29, 2008 9:41 AM from Eric White's Blog | (Comments Off) Filed under: LINQ, OpenXML, LINQ to XML, PDC2008, Functional Programming, Dynamic Types

• Build a Document Assembly Solution using Open XML SDK V2 in 5 Minutes

  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 tools, and if you are an Open XML aficionado, you really should attend our session! But even more important than that, we really want to see you, and hear your questions Read More... Posted Monday, October 13, 2008 4:50 PM from Eric White's Blog | (Comments Off) Filed under: LINQ, OpenXML, LINQ to XML, OpenXmlSdk, PDC2008, Functional Programming

• Congratulations to a Couple of Cool People

  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 with Ralf that the lights started going on for me around functional programming. So far, LINQ to XSD hasn't become a supported product (I don't know the product team's plans around Read More... Posted Tuesday, September 16, 2008 6:28 PM from Eric White's Blog | (Comments Off) Filed under: xml, OpenXML, LINQ to XML, PowerTools, OpenXmlSdk, Functional Programming