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