Lists and Schemas

In a typical system data is somewhat normalized – not all of the system's data exists in one large table or list. Instead data exists in sets of tables or lists which have one entry for each entity across multiple tables.

Hands-On Labs

  • Lists and Schema Lab

    In this lab you will work with some of the new capabilities Microsoft added to events in Windows SharePoint Services '14' as well as the new Visual Studio 2010 SharePoint Tools. You will first create a custom list definition, template and instance using Visual Studio 2010. Next, you will implement referential integrity between two SharePoint lists so that items in one list cannot be deleted until referenced items in a child list are first removed so there are no orphans. Finally, you’ll create a synchronous event receiver that is triggered when new sites are created and, when certain criteria are met, you’ll cancel the error and redirect the user to a custom application page for more information on the error.


  • Introducing SharePoint Lists and Schemas

    Introducing SharePoint Lists and Schemas

  • New and Improved Events

    In SharePoint 2010 SPListEventReceiver allows you to track events, including when a list is added. SPWebEventReceiver allows you to track web events including webs being added and sites and webs being deleted.

  • List Relationships and Joins

    The SharePoint lookup field allows you to connect an identifier of one list and to display a different, friendlier field – such as name – for users to select. SharePoint 2010 adds the ability to create additional columns which display other fields from another list. In the case of a customer, it is possible to create a lookup on the ID of the other list and not only display the customer name but to also bring across multiple other fields.

  • Large List Support

    SharePoint 2010 has support for very large lists of up to 50 million items. With this expanded list size comes the ability to throttle and control how much data is returned to the user and prevent large queries from compromising the SharePoint farm.

  • Field and List Item Validation

    SharePoint supports the ability to create Excel like field validation formulas to validate field data in a list. This greatly reduces the amount of custom code that a developer must create and deploy.