Skip to main content

Data Access

  • Chapter
  • 600 Accesses

Abstract

Everything from the site level (SPSite) down to a list item (SPListItem) can be read, modified, and saved back to the database using the API. However, before using the object model, you need a basic understanding of lists and the content type model. Different data access techniques are necessary when dealing with large sets of data. They include querying with the Collaborative Application Markup Language (CAML) and the API based on its SPQuery object. SharePoint 2010 provides extensive support for accessing lists and libraries using Language Integrated Query (LINQ). Using spmetal.exe, you can create a type-safe object layer over any existing list or library. This layer uses LINQ to access and retrieve, write, or delete data. This method has some advantages, as you will see.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Jörg Krause, Christian Langhirt, Alexander Sterff, Bernd Pehlke, Martin Döring

About this chapter

Cite this chapter

Krause, J., Langhirt, C., Sterff, A., Pehlke, B., Döring, M. (2010). Data Access. In: SharePoint 2010 as a Development Platform. Apress. https://doi.org/10.1007/978-1-4302-2707-6_4

Download citation

Publish with us

Policies and ethics