Excerpts from this SharePoint 2010 Conference talk: http://msdn.microsoft.com/en-us/sharepoint/ff462048.aspx

SharePoint 2010 has new and improved ways to work with data. LINQ to SharePoint lets a developer work with data from SharePoint lists in a strongly typed way that preserves relationships between lists. Integration of ADO.NET Data Services provides a way to get data from SharePoint remotely using REST style web services. The new Client APIs provide a programming model for SharePoint lists that doesn’t have to run on the server. This talk will demonstrate how to write code that uses each of these new data oriented features and will show some new SharePoint platform data oriented features along the way. We will also explain how to choose which data access technology is best for different custom development scenarios.

  • Powered by ADO.NET Dadta Services "Astoria"
    • REST Protocols: Atom, AtomPub, and RSS
  • Syntax:
    • /_vti_bin/ListData.svc/{Entity}[({identifier})]/[{Property}]
  • Example to get budget hours for Project $4:
    • /_vti_bin/ListData.svc/Projects(4)/BudgetHours
  • Example to get Projects for Clients in Chicago:
    • /_vti_bin/ListData.svc//Projects?$filter=Client/City eq ‘Chicago’
  • Example to get a Project and its related Client:
    • /_vti_bin/ListData.svc/Projects?$expand=Client
    • Shows me parent that is associated with this XML
  • QueryString parameters for REST
    • $filter
    • $expand
    • $orderby
    • $skip
    • $top
    • $metadata (will bring back all the XML metadata about the object. Think of it like WSDL for your REST call)
    • You can stack these parameters

      Source:William Lawrence


Dev environment hint

You need ADO.NET Data Services v1.5 CTP2 installed on server to be able to use the REST feeds. If you don’t have this installed you’ll just get blank pages with no errors.

IE8 hint

Turn off Feed Reader view in Internet Settings | Content Tab | Feed and Web Slice settings. Uncheck "Turn on feed reading view"

External References