I just came across the LINQ project two days back. Though did not have much time to try it out, but just by reading about it has got me really excited.
LINQ stands for Language Integrated Query.
LINQ project provides the ability to add general purpose query facility to the .NET framework.It can be used to query relational data sotres without leaving the compile time environment of the programming language being used.Thus we can make use of the existing CLR types to acress SQL Database directly frm or C# code. Wow!!!
Read more about it here:
Also worth watching is the Anders Hejlsberg interview on Channel 9 regarding LINQ: