C# Linq Essentials: Learn Linq Fundamentals In C# .Net (updated 6/2022)

A guide to learning the LINQ Query & Method syntax for LINQ to Objects, LINQ to Entities, LINQ to XML, & LINQ to JSON

What you'll learn

Basics of C# LINQ using both Query syntax and Method syntax. You gain upper hand than others who typically knows just one syntax.

Different types of LINQ Operators in C# .NET. You will learn them through a step-by-step approach.

Activities: Quizzes, Assignments, Coding Exercises to apply your learning. There are lots of them to help you practice!

LINQ to Objects: Get to know every LINQ operator you can apply on LINQ to Objects in C#.

LINQ to Entities: Get started with applying the LINQ concepts to access the database through entities.

LINQ to XML: Learn to apply the LINQ capabilities to work with XML including reading and writing XML using LINQ.

LINQ to JSON: Learn LINQ to JSON concepts including creating, parsing, and querying techniques of JSON.

Downloadable C# LINQ Cheat Sheet

Requirements

Basic knowledge of C# language.

VS Code or Visual Studio or any other IDE that supports C# language.

Description

Course Update History:Jun 2022: Upgraded all projects to .NET 6.0Jul 2021: NEW! Added activities for the 'Grouping Items' topic and new coding assignments.Jan 2021: NEW! Mini-course on LINQ to JSON (15 lectures)May 2022: NEW! Added Great LINQ References lecture. Enrolled Students Feedback:"I'm enjoying this course so far! Praveen has provided several supporting documents and clearly explained the expectations for this course at the very beginning…" - Tyler Bright."The content is structured and explained so well that anyone can understand and learn it easily. Access to resources has added the cherry on the cake. A great job has been done so far, and excited to explore the rest of the course." - Dinesh Mishra."The course is excellent, the instructor explains the topics well, and it's clear. Thank you." - Alejandro Monroy Vergara"Very organized and consistent. I wish the instructor had spoken more clearly. Also, I do not want to watch him fix compiler errors. I can fix my errors; I want to see code that works." - Spencer Grey."very organized!" - Yao Pan.LINQ is a core feature of the .NET runtime. It helps developers as you interact with various data sources using a few lines of code. Although it was released fifteen years back, it still holds as one of the popular features in C#. You will be learning the essential operators of the LINQ concept. My name is Praveen, and I am your instructor for this course! I had worked for about ten years in Honeywell, wherein I'd transitioned from Software Engineer to Senior Software Engineer, Tech Lead, and so on in C# .NET development. For the last six years, I've worked in the security domain for an access control product based on .NET technology. Moreover, I've published 15+ courses on various .NET technologies.Topics Covered In This CourseBasics of LINQ from scratch. Query syntax and Method syntax.Different types of LINQ Operators. You will learn them through a step-by-step approach.Activities: Quizzes, Assignments, and Coding Exercises to apply your learning. There are lots of them to help you practice!LINQ to Objects: Get to know every LINQ operator you can apply on LINQ to Objects in C#.LINQ to Entities: Get started applying the LINQ concepts to access the database through entities.LINQ to XML: Learn to apply the LINQ capabilities to work with XML, including reading and writing XML using LINQ.LINQ to JSON. Learn LINQ to JSON concepts, including creating, parsing, and querying techniques of JSON.Downloadable C# LINQ Cheat Sheet.And Many More!This course provides about five hours of content along with practice activities. To help you better, it follows a step-by-step approach to learning the essential LINQ operators.More Reasons To Take This CourseThe LINQ skills you learn from this course will be relevant in the future and aid in increasing your competency in the C# language.You can take this course without the need for any knowledge of LINQ.Each lesson in this course is bite-sized and easy to finish.At The End Of This CourseYou will have a strong foundation on C# LINQ concepts.You will know both LINQ Query and Method syntax.Also, you will gain an understanding of LINQ to Objects, LINQ to Entities, and LINQ to XML.Who Is This Course For?.NET Developers. This course will provide a strong foundation on LINQ concepts with .NET Core.PrerequisiteBasic knowledge of C# language.Visual Studio Code or Visual Studio Community Edition or Visual Studio or Visual Studio for Mac, or any other IDE that supports C#This course will provide significant knowledge of LINQ operators for your next .NET project using various data sources such as SQL, JSON, XML, etc. You will be confident to use the LINQ syntax with ease instantly.Enroll now to get started.What Do You Get When You Enroll In This Course?Lifetime access to the course and all future updates to the course contentPersonalized support and answers to your questionsUdemy certificate of completion30-Day 100% money-back guarantee

Overview

Section 1: Course Introduction

Lecture 1 Welcome & About This Course

Lecture 2 DOWNLOAD: C# LINQ Cheat Sheet

Lecture 3 DOWNLOAD: Complete Source Code

Lecture 4 Join the Official Coding Masters Group

Lecture 5 Let us Build

Lecture 6 RESOURCES: Great LINQ References

Lecture 7 Important Message About Udemy Reviews

Section 2: Getting Started with C# LINQ

Lecture 8 Introduction

Lecture 9 What is LINQ?

Lecture 10 LINQ Example

Lecture 11 3 Steps of a LINQ Operation

Lecture 12 3 Parts of a LINQ Query

Lecture 13 Significance of IEnumerable

Lecture 14 Using Var in LINQ

Lecture 15 Advantages of LINQ

Lecture 16 ACTIVITY: Coding Assignment 1

Lecture 17 Coding Assignment 1 Solution

Lecture 18 Summary

Section 3: Types of LINQ Syntax

Lecture 19 Introduction

Lecture 20 LINQ Query Syntax

Lecture 21 LINQ Method Syntax

Lecture 22 Difference between Query & Method Syntax

Lecture 23 Which Syntax to Use?

Lecture 24 Types of LINQ Operators

Lecture 25 ACTIVITY: Coding Assignment 1

Lecture 26 Coding Assignment 1 Solution

Lecture 27 Summary

Section 4: LINQ to Objects

Lecture 28 Introduction

Lecture 29 Create Custom Types

Lecture 30 Filtering Items: Where, OfType

Lecture 31 Projection Operations: Select

Lecture 32 Projection Operations: SelectMany

Lecture 33 Sorting Items: OrderBy(Descending), ThenBy(Descending), Reverse

Lecture 34 Join Operations: Join

Lecture 35 Join Operations: GroupJoin

Lecture 36 Grouping Items: GroupBy, ToLookup

Lecture 37 ACTIVITY: Coding Assignment 1

Lecture 38 Element Operations: Element, First(OrDefault), Last(OrDefault), Single

Lecture 39 Quantifier Operations: All, Any, Contains

Lecture 40 Aggregation Operations: Min, Max, Count, Average, Sum

Lecture 41 Summary

Section 5: LINQ to Entities

Lecture 42 Introduction

Lecture 43 What are LINQ to Entities?

Lecture 44 STEP 1: Create a SQLite Sample Database

Lecture 45 STEP 2: Create Entity Framewok Core Models

Lecture 46 STEP 3: Using LINQ Operators

Lecture 47 ACTIVITY: Coding Assignment 1

Lecture 48 NEW! ACTIVITY: Coding Assignment 2

Lecture 49 Summary

Section 6: LINQ to XML

Lecture 50 Introduction

Lecture 51 What is LINQ to XML?

Lecture 52 Two Uses of LINQ to XML

Lecture 53 LINQ to XML Classes

Lecture 54 Write XML using LINQ to XML

Lecture 55 Read XML using LINQ to XML

Lecture 56 Summary

Section 7: LINQ to JSON

Lecture 57 Introduction

Lecture 58 What is LINQ to JSON?

Lecture 59 LINQ to JSON Classes

Lecture 60 TIPS: Choosing JSON Classes

Lecture 61 Creating JSON: Manually

Lecture 62 Creating JSON: Declaratively

Lecture 63 Creating JSON: Using LINQ

Lecture 64 Creating JSON: From an Object

Lecture 65 Parsing JSON: From a Text

Lecture 66 Parsing JSON: From a File

Lecture 67 Querying JSON: Using Property Name

Lecture 68 Querying JSON: Using Collection Index

Lecture 69 Querying JSON: Using LINQ

Lecture 70 Querying JSON: Using SelectToken

Lecture 71 Summary

Section 8: Course Conclusion

Lecture 72 Congratulations!

Lecture 73 Bonus Lecture

.NET Developers. This course will provide a strong foundation on LINQ concepts with .NET Core.