Microsoft demonstrated a new technology at PDC called LINQ (Language Integrated Query).

The following note from Alan Griver, a member of the LINQ team at Microsoft, offers some details related to the LINQ project. In future issues of CoDe Magazine we will have more details on LINQ.

At PDC, Microsoft announced the Language Integrated Query framework (the LINQ Project). The LINQ Project is a set of language extensions to C# and Visual Basic and a unified programming model that extends the .NET Framework to offer integrated querying for objects, databases, and XML.

You can query against any of these three data sources, mixing and matching as appropriate. So, for instance, today we showed querying against a database table and an array, and then turned the output into XML.

LINQ is made up of a set of core query operators that can be applied to any .NET array or collection of objects, effectively providing SQL-like capabilities for in-memory data. Additionally, we are providing two APIs, codenamed DLinq (for SQL relational data access) and XLinq (for XML access).

These capabilities are available to any language that implements the core requirements of LINQ - currently we are showing implementations in Visual Basic and C#.

Here is a simple example of creating an array and then selecting the values over five:

Dim primes = {1, 2, 3, 5, 7, 9, 11, 13}
Dim primesOverFive = Select p From p In primes Where p > 5

The cool thing is that this works against any IEnumerable, so you can go against the .NET Framework classes as well. In this example, we get the process name from the .NET GetProcess() call and limit it to those with more than 6 threads:

Dim procs = Select p.ProcessName From p In Process.GetProcesses() Where p.Threads.Count > 6

It goes a lot further, but this is the idea. We've set up some sites with white papers, RSS feeds, and bits you can download that work with VS2005. (The online bits for C# are for Beta 2 of VS2005, the online bits for VB are for the Release Candidate of VS2005)

You'll be seeing a lot more coming from these sites.