Microsoft LINQ Using Visual C# 2010, Part 4 of 4
Interactive

Microsoft LINQ Using Visual C# 2010, Part 4 of 4

LearnNow Online
Updated Oct 26, 2018

Course description

In this course, you will learn to use the Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you will learn about the language features for Visual C# in Visual Studio 2010 in order to make LINQ possible. You will start by working 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. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you nave completed the course, you will have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.

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 familiarity with .NET in general, and with specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2010 or .NET Framework concepts, and assumes that the student is at least familiar with all the concepts covered in the Introduction to Programming and Developing Applications with Visual Studio 2010 courses.


Meet the experts

Ken Getz

Ken Getz is a featured instructor for several of our Visual Studio courses. He is a Visual Basic and Visual C# expert and has been recognized multiple times as a Microsoft MVP. Ken is a seasoned instructor, successful consultant, and the author or co-author of several best-selling books. He is a frequent speaker at technical conferences like Tech-Ed, VSLive, and DevConnections and he has written for several of the industry's most-respected publications including Visual Studio Magazine, CoDe Magazine, and MSDN Magazine.

Robert Green

Robert Green is a Visual Studio expert and a featured instructor for several of our Visual Basic and Visual C# courses. He is currently a Technical Evangelist in the Developer Platform and Evangelism (DPE) group at Microsoft. He has also worked for Microsoft on the Developer Tools marketing team and as Community Lead on the Visual Basic team. Robert has several years of consulting experience focused on developer training and is a frequent speaker at technology conferences including TechEd, VSLive, VSConnections, and Advisor Live.

Video Runtime

136 Minutes

Time to complete

176 Minutes

Course Outline

Module 7

Creating XML (28:18)

  • Introduction (00:41)
  • What About XML? (00:52)
  • Visual Basic vs C# (01:37)
  • Creating XML Content (00:31)
  • Using XMLDocument (01:16)
  • Demo: XMLDocument (02:01)
  • XML Content Using LINQ (01:12)
  • Demo: Using LINQ (03:21)
  • Traversing XML (00:35)
  • Methods (01:20)
  • Demo: Traverse (02:45)
  • Axis Methods (02:33)
  • Updating XML Content (01:06)
  • Demo: Updating Content (03:03)
  • Verifying with Schema (01:26)
  • Demo: Validating Schema (03:18)
  • Summary (00:33)

Querying XML (19:04)

  • Introduction (00:43)
  • Querying XML Content (00:25)
  • Demo: Query XML with LINQ (01:52)
  • Anonymous Types (00:32)
  • Demo: Anonymous Type (02:22)
  • Extension Methods (00:51)
  • Demo: The Any Method (02:32)
  • Lambda Expressions (00:36)
  • Demo: Lambda Expression (01:41)
  • Transforming XML (00:52)
  • Perfoming the Transformation (01:05)
  • Demo: Transforming XML (04:31)
  • Summary (00:57)
Module 8

Entity Data Model (25:33)

  • Introduction (00:44)
  • Entity Framework (00:40)
  • Entity Data Model (03:23)
  • Framework Components (01:21)
  • ObjectContext Class (01:11)
  • Entity Class (00:35)
  • Relationships (01:05)
  • Create an EDM (00:29)
  • Demo: Create an EDM (15:01)
  • Summary (01:00)

Querying Data (38:07)

  • Introduction (00:24)
  • Overview (00:37)
  • Viewing SQL (00:56)
  • Simple Queries (00:44)
  • Scalar Functions (00:15)
  • Aggregate Functions (00:29)
  • Demo: Simple Queries (06:31)
  • Demo: Aggregate Functions (02:29)
  • Related Entities (01:22)
  • Lambda Expressions (01:18)
  • Demo: Related Tables (07:55)
  • Demo: Lambda Expressions (04:28)
  • Grouping (00:52)
  • Joins (01:17)
  • Demo: Grouping (04:26)
  • Demo: Joins (03:16)
  • Summary (00:40)

Modifing Data (24:59)

  • Introduction (00:36)
  • Overview (01:23)
  • Demo: Modifying Data (02:02)
  • Demo: Add a Customer (02:21)
  • Demo: Delete a Customer (04:59)
  • Stored Procedures (01:04)
  • Demo: Stored Procedures (11:48)
  • Summary (00:42)
;