Chapter 9. Accessing Data in Lists

Microsoft SharePoint lists are intended to be viewed and edited by users. In many SharePoint solutions, however, they also act as a data source supporting create, read, update, delete, and query (CRUDQ) operations. Support for direct editing by users and programmatic access for CRUDQ operations makes SharePoint lists a unique type of data source; they act like a bound data grid and a database table all at the same time.

The dual nature of lists means that careful consideration must be given to how they are used in a SharePoint solution. While lists support CRUDQ operations, they really aren’t database tables and should not be used when the power of a database is required. Furthermore, the out-of-the-box interface ...

Get Inside Microsoft® SharePoint® 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.