EIEIOTECHNOVATION
← Training programmes

EIEIO / PROGRAMMING & DEVELOPMENT

LINQ C#

Course outline

3 days

Duration

3 days

Overview

  • Types of LINQ
  • LINQ Architecture in NET
  • Query Expressions
  • Extension Methods
  • Difference between LINQ and Stored Procedure
  • Need for LINQ
  • Advantages of LINQ

ENVIRONMENT

  • Getting Visual Studio 2022
  • Writing C# Program using LINQ

LINQ ─ QUERY OPERATORS

  • Filtering Operators
  • Filtering Operators in LINQ
  • Join Operators
  • Join Operators in LINQ
  • Projection Operations
  • Projection Operations in LINQ
  • Sorting Operators
  • Grouping Operators
  • Conversions
  • Concatenation
  • Aggregation
  • Quantifier Operations
  • Partition Operators
  • Generation Operations
  • Set Operations

LINQ ─ SQL

  • Introduction of LINQ To SQL
  • How to Use LINQ to SQL
  • Querying with LINQ to SQL
  • Insert, Update, and Delete using LINQ to SQL

OBJECTS

  • Introduction of LINQ to Objects
  • Querying in Memory Collections Using LINQ to Objects
  • Introduction of LINQ to Dataset
  • Querying Dataset using LinQ to Dataset

LINQ ─ ENTITIES

  • LINQ to Entities Query Creation and Execution Process
  • Example of ADD, UPDATE, and DELETE using LINQ with Entity Model

LINQ ─ LAMBDA EXPRESSIONS

  • Expression Lambda
  • Async Lambdas
  • Lambda in Standard Query Operators
  • Type Inference in Lambda
  • Variable Scope in Lambda Expression
  • Expression Tree
  • Statement Lambda

LINQ ─ ASPNET

  • LINQ Data Source Control
  • INSERT, UPDATE, DELETE and SELECT data in ASPNET Page using LINQ

Programme scope, delivery arrangements and suitability are confirmed during enquiry.