Accessing Data Services for Win Dev SuccessPath

Prerequisites
You should have completed our Building Windows Applications or Building Windows Store Applications paths, or have equivalent knowledge and experience.

Description
In this path you will dig deeper into accessing data from a Windows application. You will leverage two key technologies in the .NET Framework: Language Integrated Query (LINQ) and the Entity Framework. You will begin by learning to use LINQ to easily create complex data-independent queries. In addition, you will learn about the language features for Visual C# in Visual Studio in order to make LINQ possible. You will work through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. You will also be introduced to new LINQ-oriented language features: LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. You will then move on to Entity Framework and will learn some of the basics of object relational mapping systems and how they overcome some of the problems when working with relational data in an object-based application. You will see how entity objects are a big improvement over generic data objects, such as the data set and the data tables provided by ADO.NET. Then you will learn specifically about the Entity Framework, Microsoft’s ORM technology, and why it is a compelling data access technology in the .NET development space. You will discover some of the ways to create data models using the tools provided with Entity Framework and SQL Server Data Tools in Visual Studio. You will explore the XML that makes up the three Entity Data models—conceptual, storage and mapping—so that you have a good understanding of how Entity Framework implements many of its features. Finally you will see how you can customize an entity data model to make it easier for application developers to use its entity objects.


Accessing Data Services

Course Path

Accessing Data Services

23+ hours covering 60 topics

Course TitleTopicsRuntimeSkill LevelTrailer
LINQ Using Visual C# 2010 20 9h 42m Intermediate N/A
Entity Framework 6.1: Fundamentals
Entity Framework 6.1, Part 1: Introduction 7 2h 21m Advanced
Entity Framework 6.1, Part 2: Data Model 7 2h 4m Advanced
Entity Framework 6.1: Querying Data and ORM
Entity Framework 6.1, Part 3: Querying and Updating 9 2h 33m Advanced
Entity Framework 6.1, Part 4: ORM and Entities 4 1h 33m Advanced
Entity Framework 6.1: SQL Server and Code-First
Entity Framework 6.1, Part 5: SQL Server Features 4 1h 50m Advanced
Entity Framework 6.1, Part 6: Code-First Dev 9 3h 23m Advanced