Linq to SharePoint 2010 Provider by Bart De Smet

Tuesday, November 17, 2009




The LINQ to SharePoint project provides a custom query provider for LINQ that allows to query 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. its will support Custom Query Provieder that Translates Linq to CAML,the "Collaborative Application Markup Language" by SharePoint for querying by using Linq u didnt need other software to qury in caml like u2u as we know c#3.0 and vb.net 9.0 were support linq Entity Createion tool "SpMetal" to export sharepoint list definitions to entity Classes usedfor 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 wonderfull 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 enity 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);



share this post
Share to Facebook Share to Twitter Share to Google+ Share to Stumble Upon Share to Evernote Share to Blogger Share to Email Share to Yahoo Messenger More...

0 comments: