|
Menu
|
|
|
|
|
|
Course's author:
|
Go to author's Space
|
|
Course stats:
|
|
|
Favorited: |
6 times |
| |
| no vote received
|
Features
 |
Textual content |
 |
Video tutorial |
 |
Exercise |
 |
Source code |
 |
Downloads |
 |
Recommended post |
|
|
|
|
Online course
Introduction to LINQ
Learn in this LINQ Training Course the main topics regarding LINQ - Language-Integrated Query. It supports querying in-memory objects, DataSets, XML, databases... We discuss the use of 'var' in for loops, introduce the syntax of from/where/select clause. We then move into the conversion operators, demonstrate the use of ToArray() and more!
|
Use of the var keyword.
Vídeo
1) System.Func
Description: This is the beginning of a series of LINQ discussions. LINQ stands for language integrated queries. It supports querying in-memory objects, DataSets, XML, databases. |
[Mark this item as viewed]
|
Vídeo
3) ToArray() - Part II
Description: Here we continue our adventure with LINQ. We continue the discussion of ToArray() by writing a handy entension method that dumps the content of an object on the screen for debugging purposes. We explore another conversion operator: OfType(). OfType() will help us select the types that we are interested in from a mix of types. |
[Mark this item as viewed]
|
Vídeo
4) Cast(), AsEnumerable(), and ToList()
Description: In this video, we continue the discussion of conversion operators. We explore Cast(), AsEnumerable(), and ToList(). Cast() will throw an exception if an item cannot be cast to a specific type. AsEnumerable will help us get a list of items that we can enumerate. And finally, we use ToList() to convert an array into a list. |
[Mark this item as viewed]
|
Vídeo
5) ToDictionary() and ToLookup()
Description: In this video, I will discuss couple more conversion operators: ToDictionary() and
ToLookup(). As the name implies, ToDictionary() will covert a list to a dictionary
with a specified key. ToLookup() will take the dictionary a step further by supporting
elements with the same key. |
[Mark this item as viewed]
|
Lambda expressions
Vídeo
6) Lambda expressions
Description: This is a continuation of the LINQ discussion. In this video, I will be discussing lambda expressions. lambda expressions are brief inline functions, or concise delegates. Specifically, I will be covering Action and Predicate. An action is a method that takes
no argument. Predicate evaluates an expression and returns a boolean. We will use an employee class to show how Action work, and we will use a list of ints to show the use
of predicates. |
[Mark this item as viewed]
|
Vídeo
7) Func
Description: We continue the lambda expression discussion here by covering Func. Func is a method that takes some arguments and returns a value. I will use an array of strings to show how Func works. Then, I will discuss the evolution of delegates from simple delegates to anonymous delegates to lambda expressions. |
[Mark this item as viewed]
|
Operators and methods
Vídeo
8) Yield return and Yield break
Description: In this and the next few videos, I am going to discuss a list of operators and methods. For every item, I will give a brief definition and an example on how it can be used.
Here are the items discussed in this video: yield return (which get the .NET Framework to generate an enumerable type collection) and yield break (which breaks out of the collection generation. Finally select which Queries a collection for a list of values. |
[Mark this item as viewed]
|
Vídeo
9) Select
Description: We start this video by explaining the select code from the previous video since we ran out of time. Then we move into where which limits the collection returned by select to a list of items that satisfies the where clause, order by which sorts the elements in a specific order (ascending, descending). |
[Mark this item as viewed]
|
Vídeo
10) Reverse
Description: This video illustrates the use of reverse which, as the name implies, reverses a list of items. Then we move into any and all which return a boolean value that indicates whether the elements in a list satisfy a condition. contains: returns a boolean value that indicates whether a list contains an element (or not). skip: skips a list of elements from a list. |
[Mark this item as viewed]
|
Vídeo
11) Take, Range and SequenceEqual
Description: Our LINQ discussion continues with take: selects an indicated number of elements from the list. Take works well with skip when paging a datagrid (web applications).
Enumerable contains helpful methods such as Range (which gives us a range of values
between and min and a max) and Repeat (which repeats a certain values a number of times).
Repeat comes handy when creating a list of test objects for debugging purposes. |
[Mark this item as viewed]
|
Vídeo
13) SQL
Description: Like SQL, LINQ supports sorting and grouping elements. This video will cover orderby and group by to order and group elements. We will cover sorting in ascending and descending
order and look at the details of grouping a list of numbers by odd and even groups. |
[Mark this item as viewed]
|
Vídeo
14) Aggregate and average
Description: This video will start by discussing aggregate and average. Aggregate is an extension method for accumulating sequences into single values. Average, as the name implies, finds the average of a list of values. We wrap up this video by showing how LINQ commands can be chained together to reduce the amount of code written. |
[Mark this item as viewed]
|
Vídeo
15) Min(), Max(), and Distinct()
Description: In this video, we will discuss Min(), Max(), and Distinct(). Min helps us find the smallest value in a collection and Max will find the largest value. We will see how we can pass a lambda expression to Min to find the list of words with smallest length. Finally, we discuss the use of Distinct to remove duplicates from a list of grades,
and find their median. |
[Mark this item as viewed]
|
Vídeo
16) Except(), Intersect() and Union()
Description: Except(), Intersect() and Union() are the subjects of this video. The Except extension method returns the elements that are in the source object and not in the argument
object. Intersect extension method returns only those elements in the source sequence that are also in the target sequence. The Union extension method adds two sequences
together and returns the unique members found in both sequences. |
[Mark this item as viewed]
|
|
