Linq to SharePoint 2010 Custom Provider

Introduction

The LINQ to SharePoint project provides a custom query provider for LINQ that allows querying SharePoint lists using familiar LINQ syntax. LINQ stands for Language Integrated Query and is one of the core features of Microsoft's .NET Framework 3.5 release. 

it will support Custom Query Provider that Translates LINQ  to CAML, the "Collaborative Application Markup Language" by SharePoint for querying by using LINQ  you  didn’t need other software to query in caml like u2u as we know c#3.0 and vb.net 9.0 were support LINQ  Entity Creation tool "SpMetal" to export SharePoint list definitions to entity Classes used for Querying and Visual Studio 2008 integration for entity Creation (a.ka SPML) make it more essay and simple you can connect sp site either using SharePoint Object Model or via the Share Point Web services Planned to Support for updating through Entity type.

This wonderful Solution Invented by former Visual C# MVP, Bart De Smet now works at Microsoft Corporation on the WPF dev team in an SDE role. So enjoy with SharePoint to LINQ .

Sample

Updated for the 0.2.2.0 alpha release
var ctx = new SharePointDataContext(new Uri("http://wss.mycompany.local"));
ctx.Log = Console.Out;
var users = ctx.GetList(ctx);

var res = from u in users
orderby u.Birthdate descending
where u.FirstName.StartsWith("B") && u.Age >= 24 && u.FavoriteFood == FavoriteFood.Pizza
select new { u.FullName, u.Age, Interest = u.AccountBalance * 0.07 };

foreach (var u in res)
Console.WriteLine(u);

i hope this is help to you all.