LINQ Fundamentals in C# 10

Focused View

Paul D. Sheriff

3:50:40

10 View

01. Course Overview

01. Course Overview.mp4

01:35

02. Where LINQ Fits into Your Toolbelt

02. Introduction and Version Information.mp4

01:34

03. Whats in This Course and Community Resources.mp4

01:14

04. What Is LINQ and LINQ Integrations.mp4

02:13

05. Examples of SQL C.Sharp Loops and LINQ.mp4

04:14

06. Why Use LINQ and LINQ Operations.mp4

02:30

03. Use LINQ to Select Data within Collections

07. The Console Application Used for LINQ Samples.mp4

01:28

08. The Sample Entity Repository and View Model Classes.mp4

03:20

09. Select All Items Using LINQ.mp4

05:51

10. Select a Single Column.mp4

03:09

11. Get Specific Columns to Load into a Product Object.mp4

03:02

12. Build an Anonymous Class.mp4

03:49

04. Use LINQ to Order Data

13. Sorting Data on a Single Field.mp4

02:55

14. Sorting Data in Descending Order.mp4

01:29

15. Sort the Data Using Two Fields.mp4

02:45

16. Sort Two Fields Descending Using the Method Syntax.mp4

01:33

05. Use the LINQ Where Clause to Filter Data

17. Using the Where Clause.mp4

02:58

18. Using the And Operator.mp4

02:05

19. Custom Extension Methods.mp4

01:20

20. Demo of a Custom Extension Method.mp4

02:44

06. Select a Single Piece of Data from a Collection

21. The Methods for Selecting a Specific Item.mp4

03:35

22. Search Forward for an Element Using First.mp4

01:59

23. Search Forward for an Element Using FirstOrDefault.mp4

02:39

24. Search Backward for an Element Using Last.mp4

01:43

25. Search Backward for an Element Using LastOrDefault.mp4

01:43

26. Searching for Only One Element Using Single.mp4

03:00

27. Searching for Only One Element Using SingleOrDefault.mp4

02:37

28. When to Use Which Method.mp4

03:36

07. Retrieve Specific Items Using Take Skip Distinct and Chunk

29. Using the Take Method to Extract Data.mp4

02:27

30. Using the Range Operator with the Take Method.mp4

02:58

31. Conditionally Extract Data Using the TakeWhile Method.mp4

01:20

32. Skip Past Beginning Elements in a Collection.mp4

02:42

33. Get Distinct Values from a Collection.mp4

01:58

34. Extract Distinct Objects Using DistinctBy Method.mp4

02:13

35. Split Large Collections into Smaller Collections Using Chunk.mp4

03:02

08. Determine the Type of Data Contained within Collections

36. Introduction to the All Method.mp4

01:35

37. Demo of the All Method.mp4

02:45

38. Demo of the Any Method.mp4

02:04

39. Demo of Contains Using Integers.mp4

01:32

40. Demo of Contains Using Comparer Class.mp4

04:54

09. Determine Differences between Two Collections

41. Using SequenceEqual with Integer Collections.mp4

04:02

42. Using SequenceEqual with Object Collections.mp4

01:51

43. Using SequenceEqual with Comparer Class.mp4

02:49

44. Using Except with Integer Collections.mp4

02:30

45. Find Products That Do Not Have Sales Using Except.mp4

02:29

46. Using Except with Comparer Class.mp4

02:03

47. Using the ExceptBy Method.mp4

01:57

48. Find Products That Do Not Have Sales Using ExceptBy.mp4

02:19

49. Using Intersect with Integer Collections.mp4

01:20

50. Find Products That Have Sales Using Intersect.mp4

01:36

51. Using Intersect with Comparer Class.mp4

01:24

52. Using the IntersectBy Method.mp4

01:25

53. Find Products That Have Sales Using IntersectBy.mp4

02:26

10. Concatenate Collections Together Using Union and Concat

54. Using Union with Integer Collections.mp4

01:52

55. Using Union with Comparer Class.mp4

01:11

56. Using the UnionBy Method.mp4

01:24

57. Using Concat with Two Integer Collections.mp4

01:18

58. Using Concat with Two Product Collections.mp4

01:38

11. Use the Join Clause to Combine Two Collections

59. Performing an Inner Join.mp4

04:39

60. Using a Two-field Inner Join.mp4

02:30

61. Using the into Keyword.mp4

03:12

62. Using the GroupJoin Method.mp4

01:18

63. Simulating a Left Outer Join Query Syntax.mp4

04:17

64. Simulating a Left Outer Join Method Syntax.mp4

02:33

12. Use the Group Clause to Produce Grouped Collections

65. Grouping Products by Size.mp4

03:41

66. Ordering by the Key Property.mp4

01:56

67. Filtering the Grouped Data.mp4

02:31

68. Creating a One-to-many Using a Subquery.mp4

04:05

69. Simulate Distinct Using Group By.mp4

02:07

13. Aggregate Data in Collections

70. Using Count and Filtering the Count.mp4

02:53

71. Using Min and Max Methods.mp4

02:25

72. Using MinBy and MaxBy Methods.mp4

01:55

73. Using Average and Sum Methods.mp4

02:22

74. Simulate Sum Using Aggregate.mp4

02:28

75. Using Aggregate Method with a Custom Expression.mp4

01:26

76. Using Grouping with Aggregation.mp4

04:00

77. Making Aggregation More Efficient.mp4

05:15

14. Use LINQ to Iterate over Collections

78. Using ForEach to Calculate a Line Total.mp4

03:35

79. Using ForEach and a Sub-query to Calculate Total Sales.mp4

02:11

80. Call a Custom Method from ForEach.mp4

03:11

15. Understanding Deferred Execution Streaming and Non-streaming Operations

81. Classification of LINQ Queries.mp4

01:55

82. Deferred Execution Streaming and Non-streaming.mp4

03:40

83. The Classes for Illustrating Deferred Execution.mp4

01:40

84. Illustrating Deferred Execution Using ForEach.mp4

04:32

85. Step-through Demo of Deferred Execution.mp4

02:22

86. Using IEnumerator and GetEnumerator.mp4

02:01

87. Show Streaming Nature of Where and Take Methods.mp4

01:57

88. Create Custom Filtering Extension Method.mp4

03:22

89. Apply Take to Custom Filtering Method.mp4

00:57

90. Use Yield Keyword to Create Streaming Extension Method.mp4

03:13

91. Use the Yield Keyword with Take Method.mp4

00:55

92. Use the Yield Keyword with OrderBy Method.mp4

01:52

Description

This course teaches you how to use the LINQ syntax to select, filter, extract, partition, identify, union, join, group, and aggregate data contained in C# collections.

What You'll Learn?

LINQ can filter and extract data from collections efficiently. In this course, LINQ Fundamentals in C# 10, you’ll learn to apply LINQ queries to sets of data to extract meaningful information in an efficient manner. First, you’ll explore how to create LINQ queries, where to learn more about LINQ, and how to select and order data from sets of data. Next, you’ll discover how to filter data, get distinct values, and identify the kind of data contained within collections. Finally, you’ll learn how to work with multiple sets of data, group data into sets, and aggregate data to produce statistics for solving business problems. When you’re finished with this course, you’ll have the skills and knowledge of LINQ needed to apply queries in your everyday applications to produce data efficiently.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

C#

Paul D. Sheriff

Instructor's Courses

Paul has over thirty years of experience architecting information systems and his expertise is in much demand from Fortune 500 companies. Paul is a Pluralsight author, has published 400+ articles, and authored over 14 books on topics ranging from JavaScript, Angular, C#, SQL Server and many .NET technologies. Paul is a frequent speaker at conferences and user groups.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.