C#.NET LINQ Tutorial - LINQ Fundamentals

Name: C#.NET LINQ Tutorial - LINQ Fundamentals
Rating: 3.8 (50 reviews)

Learn Language Integrated Query basics, improve your querying skills!

Created byEmre Şavklı

Last updated 10/2015

English

English [Auto],

What you'll learn

Learn how to query data collections and data sources by LINQ
Use Func delegate and Lambda Expression into LINQ Extension Methods easily.
Learn how interfaces implement into a class.
Learn LINQ expression query set and LINQ extension method usage.

Course content

2 sections • 20 lectures • 2h 21m total length

What is Language Integrated Query3:50
Learn the fundamentals of language integrated query, linq, in dot net, spanning its architecture, data sources, and why to use linq for querying objects, datasets, and databases.
Hello LINQ - First Application6:50
Learn the basics of linq in a C# console app by creating a first collection of numbers, querying with from and select, iterating with foreach, and filtering numbers under 50.
Using Lambda Expression and Func Delegate11:23
This lecture contains Func delegate and Lambda Expression usage basics. You will learn why we declare lambda expression for passing to extension method parameters.
Extension Methods7:50
[Quiz] Exercise on Introduction To LINQ

Projection Query - Select4:02
Projection-Select Many Operation3:39
OrderBy, OrderByDescending13:10
Homework - Sorting Operations0:37
Filtering Operations - Where and OfType<T>11:05
Homework - Filtering Operations0:39
[Quiz] Exercise on Querying Object Collections By LINQ
Grouping Operations - GroupBy10:14
Master grouping operations with group by to group a sequence by a key, using key selectors and overloads; explore examples like grouping names by length or by first letter.
Aggregation Operations - Count11:51
Learn aggregation operations in c#.net linq, including count, long count, max, and aggregates via anonymous objects; count elements, filter evens, and group order details to compute per order product counts.
Aggregation Operations - Sum7:28
Learn to use the Sum extension in LINQ to total numeric collections and object collections with selectors, including grouping orders and summing unit price times quantity.
Aggregation Operations - Average7:11
Learn how to use the average extension method in LINQ to compute department-wise average ages from an employee list, with parameterless and selector variants, and return anonymous result objects.
Aggregation Operations - Max & Min11:06
[Quiz] Exercise on Aggregation and GroupBy Operations
Set Operations - Distinct13:33
This lecture is introduction of "Set Operations". This chapter contains basic usage of distinct and query via custom comparer objects as well.
Set Operations - Intersect & Except5:50
Explore c#.net linq fundamentals with intersect and except set operations, comparing two sequences, using a second sequence and optional custom comparer, plus a practical course enrollment example.
Set Operations - Union3:09
Quantifier Operations - All and Any5:41
Learn Linq all and any to test conditions across a sequence. See a product list that verifies whether all products are discounted or if any are discounted using lambda predicates.
Quantifier Operations - Contains2:18
Explore the contains quantifier in Linq fundamentals by using the contains extension method to check whether a sequence contains a value, with a customer list example and custom comparers.

Requirements

Download and setup Visual Studio 2013 Express Edition. Pre-study and learn C#.NET on basic to intermediate level and object oriented principles

Description

Microsoft developers have been using both OR/M tools,which are LINQ To SQL and Entity Framework, for a long time. Also XML querying operations appear in many projects. For using these technologies, you must be skilled on query technics. LINQ ensures you to create queries efficiently.

In this course you will learn querying by LINQ(Language Integrated Query) properly. We will study totally 2 main chapters during the course. These are; Introduction to LINQ and Query Object Collections.

This tutorial appeals to .NET developers by using C# .NET language. So, before this course you must learn C#.NET basics and Object Oriented Programming principles.

Main purpose of this tutorial is making the best beginning to Language Integrated Query.

If you follow lecture order and practice whole examples, at the end of tutorial you can easily create queries that all on your need.

Practice homeworks and answer quiz questions. These tasks are given you to improve your querying skills.

Have a nice learn !

Yours sincerely...

Who this course is for:

This course appeals to C# .NET Developers who know about the base of C#.NET Language and Object Oriented Programming Principle

C#.NET LINQ Tutorial - LINQ Fundamentals

What you'll learn

Explore related topics

Course content

Introduction To LINQ4 lectures • 30min

Querying Object Collections By LINQ16 lectures • 1hr 52min

Requirements

Description

Who this course is for: