LINQ Programming with C# 3.0
COURSE OUTLINE:
Prerequisites
This course requires proficiency in the C# language and general ADO.NET technologies. Classes available to satisfy these requirements include:
• C# 3.0 Programming
Learning Objectives
Introduction to LINQ
• What is LINQ?
• What problems does LINQ solve?
• LINQ Technologies
• LINQ assemblies and namespaces
• Query operators and expressions
• Writing your first LINQ query
• LINQ learning tools
C# 3.0 Language Features
• Implicitly typed local variables
• Extension methods
• Default properties
• Object initialization
• Array initialization
• Anonymous types
• Lambda expressions
LINQ to Objects
• What is LINQ to Objects?
• Selecting data from collections
• Projecting data with anonymous types
• Filtering data from collections
• Performing join operations
• Grouping data
• Sorting data
• Aggregating data
• Selecting distinct objects
Lambda Expressions
• Understanding lambda expressions
• The relationship between delegates and lambdas
• The System.Func delegate
• Key extension methods
• Working with Lambda Expressions
LINQ to DataSets
• What is LINQ to DataSets?
• Key LINQ to DataSets classes
• Selecting data from a DataTable
• Joining DataTables
• Sorting data from DataTables
• Working with typed DataSets
• Using lambda expressions to query DataTables
Getting Started with LINQ to SQL
• What is LINQ to SQL?
• Key LINQ to SQL classes
• Deferred loading versus immediate loading
• Creating LINQ to SQL entity classes
• Entity class attributes
• Creating relationships with EntitySet