LINQ Fundamentals with C# 6.0

Visit Tutorial Page ( Report)

LINQ introduced radical changes to the C# language. In this course, LINQ Fundamentals with C# 6.0, you'll see features of the C# language that make LINQ work, as well as how to use LINQ effectively using practical examples. You'll start with seeing a demonstration of the power of LINQ along with some of the important features of the C# language for LINQ, including how to create and use extension methods and lambda expressions. Next, you'll focus on the behavior of LINQ queries and start to work with realistic data to learn how to filter, order, and project data. Finally, you'll see some demonstrations on how to use LINQ to XML as well as, how LINQ works with a remote datasource by using the Entity Framework against Microsoft SQL Server. By the end of this course, you'll be ready to process and query in-memory data, as well as work with XML and a SQL Server database.

  • Course Overview
    00:01:25
  • An Introduction
    00:14:06
    • The Start
      00:00:31
    • What is LINQ
      00:01:28
    • Writing a Report without LINQ
      00:07:11
    • Writing a Report with LINQ
      00:03:46
    • The Roadmap
      00:01:09
  • LINQ and C#
    00:45:54
    • Introduction
      00:00:39
    • Evolving the Language
      00:02:21
    • The Power of IEnumerable
      00:06:14
    • Creating an Extension Method
      00:07:39
    • Understanding Lambda Expressions
      00:08:16
    • Using Func adn Action Types
      00:07:49
    • Using Var for Implicit Typing
      00:04:07
    • Query Syntax versus Method Syntax
      00:07:33
    • Summary
      00:01:13
  • LINQ Queries
    00:37:19
    • Introduction
      00:00:36
    • Create a Custom Filter Operator
      00:06:11
    • Creating a Operator with Yield Return
      00:05:59
    • Deferred Execution Explained
      00:01:46
    • Taking Advantage of Deferred Execution
      00:06:23
    • Avoiding Pitfalls of Deferred Execution
      00:03:39
    • All About Streaming Operators
      00:04:53
    • Querying Infinity
      00:04:17
    • Summary
      00:00:42
  • Filter, Ordering & Projecting
    00:43:05
    • Introduction
      00:00:28
    • A File Full of Fuel Efficiency
      00:03:09
    • How to Process a CSV File with LINQ
      00:01:34
    • Implementing a File Processor
      00:09:07
    • Finding the Most Fuel Efficient Car
      00:05:26
    • Filtering with Where and First
      00:07:48
    • Quantifying Data with Any, All, Contains
      00:02:36
    • Projecting Data with Select
      00:07:21
    • Flattening Data with SelectMany
      00:04:48
    • Summary
      00:00:43
  • Joining, Grouping & Aggregating
    00:48:43
    • Introduction
      00:00:23
    • Adding a second Data Source
      00:03:32
    • Joining Data with Query Syntax
      00:05:37
    • Joining Data Using Method Syntax
      00:07:09
    • Creating a Join with a Composite Key
      00:02:45
    • Grouping Data
      00:06:35
    • Using a GroupJoin for Hierarchical Data
      00:06:44
    • Challenge Answer: Group by Country
      00:03:18
    • Aggregating Data
      00:04:09
    • Efficient Aggregation with Extension Methods
      00:07:44
    • Summary
      00:00:40
  • LINQ to XML
    00:32:46
    • Introduction
      00:00:51
    • System.Xml.Linq
      00:00:51
    • Building Element-oriented XML
      00:07:21
    • Functional Construction for Less Code
      00:05:13
    • Load and Query XML with LINQ
      00:07:59
    • Working with XML Namespaces
      00:08:57
    • Summary
      00:00:57
  • LINQ and the Entity Framework
    00:39:40
    • Introduction
      00:00:42
    • Setting up the Entity Framework
      00:05:56
    • Inserting Data into a New Database
      00:05:53
    • Writing a Basic Query with LINQ
      00:05:05
    • Caveats and Pitfalls of Remote LINQ
      00:07:40
    • An Advanced LINQ Query
      00:07:40
    • Summary
      00:01:08
Write Your Review

Reviews

Sana Kapoor
Sana Kapoor

0 0 (Report)