Learn your way! Get started

SharePoint 2013 Developer, Part 14: BCS

with expert Tim McCarthy

Watch trailer

SharePoint 2013 Developer, Part 14: BCS Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 3/23/2014
Level Level Advanced
Runtime Runtime 1h 20m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Closed captioning Closed captioning Included
Transcript Transcript Included
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs N/A
Sample code Sample code Included
Exams Exams Included

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

The main capability of Business Connectivity Services (BCS) in SharePoint 2013 is to expose line of business (LOB) data as external content types. Once defined, then then BCS allows the creation of lists that use the external content types which then have all of the rich goodness of standard SharePoint lists. The external data can be anything from database sources to WCF web services or even OData REST web services. After this course, you will understand the nuances of BCS and how to create external content types using both SharePoint Designer 2013 and Visual Studio 2013. You will also learn how to consume WCF web services as well as REST web services that use the OData protocol.


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

Prepare for certification

This course will help you prepare for:
70-489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
70-488 Developing Microsoft SharePoint Server 2013 Core Solutions

This course will help you earn:
MCSD: SharePoint Applications

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 & 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 & .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.

Course outline

Business Connectivity Services

Business Connectivity Services (12:49)
  • Introduction (00:19)
  • Business Connectivity Service (02:31)
  • What BCS Does (02:10)
  • Concepts (01:55)
  • Security/Connection Management (01:56)
  • Demo: Looking at Secure Store (03:46)
  • Summary (00:09)
Tooling (35:29)
  • Introduction (00:18)
  • Tooling (00:29)
  • Tooling-cont- (02:41)
  • Demo: Creating External Conte (13:25)
  • Adding Behavior (02:08)
  • Adding Behavior-cont- (00:44)
  • Demo: Adding Behavior (04:36)
  • Filters (02:23)
  • External Data Column (01:14)
  • Demo: Adding external data (06:14)
  • Search and Profile Pages (00:50)
  • Summary (00:23)
VisualStudio (10:16)
  • Introduction (00:15)
  • Business Data Connectivity Model (01:01)
  • Migrating Declarative Models (00:53)
  • Demo: Creating Visual Studio (07:53)
  • Summary (00:13)
Consuming Web Pages (21:51)
  • Introduction (00:15)
  • Consuming Web Services (01:06)
  • REST API (01:53)
  • REST API (cont) (00:44)
  • OData Protocol (00:49)
  • Consuming OData Sources (01:32)
  • Rest and OData Demo (04:56)
  • connect OData Demo (cont.) (04:20)
  • connect BCD model Demo (cont.) (05:57)
  • Summary (00:14)