SharePoint 2013 Developer, Part 05 of 15: Programming Lists

Course description

Lists are the core data structure for persisting all data in SharePoint solutions, therefore it is essential to know to properly create them and how to query them efficiently. We will cover creating both lists and their views and how to use the CAML query language in order to be able to write the most performant queries on those lists as well as using LINQ for SharePoint. After this course you will have the know-how to know when to use the right type of query method for getting data out of SharePoint lists.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course assumes that students have some Web development background and some experience using Visual Studio 2012.

Meet the expert

Tim McCarthy

Tim McCarthy is a senior solutions architect with Perficient who designs and builds highly scalable, layered web, desktop, and mobile applications utilizing the latest Microsoft platforms and technologies. His expertise covers a wide range of Microsoft technologies including SharePoint/Office 365, Office Apps, Windows Phone, Windows 8, Azure, .NET Framework (ASP.NET, VSTO, Workflow, WCF, WPF), SQL Server, Active Directory, MS Exchange development, and Service Oriented Architecture (SOA) applications. Tim holds multiple Microsoft certifications and is a former Microsoft MVP in Solutions Architecture. He is the author of several books, has developed presentations for the Microsoft Developer Network (MSDN), and has written articles for SQL Server Magazine and Windows and .NET Magazine. He has been a featured speaker at conferences, user groups, and code camps worldwide. Before becoming an application developer, Tim was an officer in the United States Marine Corps.

Video Runtime

89 Minutes

Time to complete

242 Minutes

Course Outline

Programming Lists

Programming Lists (44:12)

• Introduction (00:14)
• Lists and Libraries (02:36)
• Retrieve List Instances (01:47)
• Demo: Retrieving List Instances (03:36)
• Demo: Counting List Items (04:44)
• Demo: Using the GUID Indexer (03:52)
• Demo: Using the GetList method (03:34)
• Creating Lists with Server Code (02:33)
• Demo: Lists with Server Code (05:59)
• Demo: Deleting Lists (02:16)
• Demo: Binding a Content Type (04:47)
• Views (01:10)
• Demo: Views (03:33)
• Demo: Static Titles (03:12)
• Summary (00:11)

Retrieving Items (45:22)

• Introduction (00:16)
• Retrieving Items with Server Code (01:56)
• CAML Queries (02:09)
• SPQuery Class (00:38)
• SPSiteDataQuery Class (01:12)
• Query Properties (00:52)
• ViewFields Property (00:35)
• Query Property (00:37)
• Comparison Operators (00:09)
• SPSiteDataQuery Additions (01:22)
• Demo: Creating a CAML Query (04:19)
• Demo: Extracting a Query (04:21)
• Demo: CreateChildControls (03:24)
• Joins (01:31)
• Demo: Joins (05:40)
• Demo: Clean Up Lookup Fields (01:45)
• LINQ with SharePoint (02:40)
• Demo: LINQ Queries (03:36)
• Demo: Web Part with LINQ (03:11)
• Demo: Adding a Web Part (03:42)
• Microsoft.SharePoint.Linq Limits (01:01)
• Summary (00:14)