Mastering LINQ with C# Training Course

Duration

14 hours (usually 2 days including breaks)

Requirements

  • An understanding of programming

Audience

  • Web Developers

Overview

C# is a multi-paradigm programming language encompassing object-oriented and component-oriented disciplines. LINQ (language integrated query) is a component that adds native data querying capabilities to programming languages.

This instructor-led, live training (online or onsite) is aimed at web developers who wish to query and update big data with LINQ using C#.

By the end of this training, participants will be able to:

  • Create and execute LINQ queries.
  • Implement advanced libraries for data querying.
  • Filter, search, transform, and manipulate local or remote objects.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

LINQ Basics

  • IEnumerable<T>
  • IEnumerator<T>
  • Projection, filtering, quantifiers, partitions, operations, etc.

Overview of LINQ Operators

  • Immediate vs deferred executions
  • Streaming vs non-streaming operators

Preparing the Development Environment

  • Installing and configuring .NET
  • Installing and configuring LINQPad

Simple LINQ Queries

  • Selecting a data source
  • Creating a query
  • Executing a query

Data Transformation and Type Relationships

  • Returning results as a type
  • Performing operations on source elements
  • Allowing the compiler to select types

Grouping and Joining LINQ Queries

  • Grouping by multiple keys
  • Extending a group query
  • Grouping with custom keys
  • Using inner join with composite key
  • Using group join and inner group join

LINQ with Lambda Operators

  • Understanding method syntax with Lambda operators
  • Grouping by multi-keys
  • Grouping by custom keys and custom objects
  • Using inner join and composite join
  • Using group join and group inner join

Standard and Complex Queries

  • Filtering subsets
  • Rearranging data with an operator
  • Parsing basic groups
  • Creating a hierarchy in a data set
  • Chaining data
  • Using into and let keywords

LINQ to SQL

  • Setting up a database
  • Querying a database
  • Updating a database

LINQ to XML

  • Creating a tree
  • Using tree queries

Summary and Conclusion

Leave a Reply

Your email address will not be published. Required fields are marked *