Home About Courses Schedule Services Webinars Contact Search

Language Integrated Query (LINQ) for C# Developers

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: NE4070


Audience

C# programmers who will be using LINQ to access data within a Windows environment.

Description

This course will review significant .NET 3.5 through 4.5 features and functionality focusing on the use of LINQ to access XML and Object Data sources.

Objectives

Upon successful completion of this course, the student will be able to:

  • Discuss .NET 3.5 – 4.5 features.
  • Use ArrayLists and Hashtable Collections
  • Use Generic Collections
  • Use the var implicit type reference
  • Use lamba expressions
  • Use LINQ to perform data access against XML, Object data sources and ADO Datasets

Prerequisites

Programming background in C# or attended an Introduction to .NET using C# training class.

Topics

  • I.NET Framework
    • Overview
    • Common Language Runtime(CLR)
    • .NET Framework updates
      • implicitly typed local vaiables
      • anonymous types
      • Lambda expressions
  • II.C# Review
    • Delegates and Events
    • Collections
      • ArrayList
      • HashTables/HashSets
    • Cast versus OfType
    • Generic Collections
    • Interface
      • IEnumerable interface
  • III.C# Features
    • Named Methods
    • Anonymous Methods
    • Lambda Expressions
    • var keyword
    • Object Initialization
    • Anonymous Types
    • Workshop - Lambda Expressions
  • IV.LINQ
    • Overview
    • Query operations and expressions
      • Sorting Data
      • Filtering Data
      • Projection Operations
      • Join Operations
      • Converting Data Types
      • Aggregation Operations
    • LINQ to Objects
      • Query an Arraylist
      • Strings
    • Workshop - Expressions
    • LINQ to DataSets
      • DataSet Fields
    • Workshop - DataSets
  • V.LINQ to XML
    • Compared to DOM
    • Querying XML Trees
    • Modifying Elements, Attributes, and nodes in an XML Tree
    • Traversing trees
    • Workshop – XML