Training Course

LINQ (Language Integrated Query) makes the concept of querying a first-class programming concept in .NET. The data to be queried can take the form of XML (LINQ to XML), databases (LINQ-enabled ADO.NET: LINQ to SQL, LINQ to Dataset and LINQ to Entities) and objects (LINQ to Objects). Our LINQ training course makes the developer proficient enough to use language integrated query as an alternative to SQL Queries and to prove how LINQ will be a better way of handling XML documents. Astro Computer Education's training in LINQ tutorial helps students to frame the queries easily in LINQ and how to learn LINQ efficiently.

Overview

LINQ & Entity Framework Training

LINQ (Language Integrated Query) makes the concept of querying a first-class programming concept in .NET. The data to be queried can take the form of XML (LINQ to XML), databases (LINQ-enabled ADO.NET: LINQ to SQL, LINQ to Dataset and LINQ to Entities) and objects (LINQ to Objects). Our LINQ training course makes the developer proficient enough to use language integrated query as an alternative to SQL Queries and to prove how LINQ will be a better way of handling XML documents. Astro Computer Education's training in LINQ tutorial helps students to frame the queries easily in LINQ and how to learn LINQ efficiently.

EntityFramework ADO.NET Entity Framework is an object-relational mapping(ORM) framework for the .NET Framework. It is designed to enable developers to create data access applications by programming against a conceptual application model instead of programming directly against a relational storage schema. It eliminates the need for most of the data-access code that developers usually need to write. So in this Online Entity Framework Tutorial you will understand how decent amount of code is been decreased and you’ll also learn how maintenance is required for data-oriented applications.


LINQ & Entity Framework Training Objectives

  1. To leverage new features of C# including extension methods and lambda expressions.
  2. To understand LINQ Architecture and role of LINQ providers
  3. To write LINQ queries to filter, sort, and group in-memory collections of objects.
  4. Create LINQ to SQL queries to execute SQL Server stored procedures and perform CRUD database operations.
  5. To manage XML documents using LINQ to XML.
  6. To understand how LINQ can be used to manage data in dataset.
  7. To understand Entity Framework Architecture
  8. To generate EDMX file from database and perform CRUD operations.
  9. To use LINQ to Entities to write strongly typed queries against the Entity Data Model.
  10. To develop N-Tier Application using EF and LINQ.

Prerequisites

  1. C# and specially OOPS and Delegates.
  2. Sql-Server tables and stored procedures.

LINQ & Entity Framework Training Duration

Regular classroom based training: 6 Weeks, 60 minutes of theory & practical session per day.

Modules

LINQ & Entity Framework Syllabus

  1. Type Inference
  2. Object Initializers
  3. Anonymous Types
  4. Extension Methods
  5. Partial Methods
  1. Understanding the LINQ Framework
  2. LINQ Provider
    1. LINQ to Object
    2. LINQ to SQL
    3. LINQ to Dataset
    4. LINQ to XML
  1. IEnumerable and IQueryable interface
  2. System.LINQ namespace
  3. Query Expressions
  4. Lambda Expressions
  5. Using Custom Class Collection
  1. Defining the Data Model class
  2. Using Mapping attributes
  3. Using the Data Context class
  4. Defining Relationships using Associations
  5. Creating a customized Data Context class
  6. LINQ to SQL Designer(DBML File)
  7. Performing Add/Edit/Delete/View Operations
  8. Tracking changes to entities
  9. Submitting changes
  10. Concurrency error handling issues
  11. Join Query
  12. Validating Entities
  13. Transaction Handling
  14. Executing Stored Procedure
  15. LINQ to SQL architecture
  1. Understanding the LINQ to XML Class hierarchy
  2. Create an XML document
  3. Loading existing XML document
  4. Querying XML using LINQ to XML
  5. Manipulating XML
    1. Adding nodes
    2. Modifying nodes
    3. Deleting nodes
  1. Querying Datasets
  2. Querying typed Datasets
  3. Using LINQ over Dataset with Table Adapter
  1. What is ADO.NET Entity Framework
  2. Comparing EF with LINQ to SQL
  3. EF Architecture
  4. EF Versions History
  5. First EF Application and Creating EDMX File
  6. DbContextvsObjectContext
  1. Members of DbContext and DbSet
  2. Entity Life Cycle and ObjectStateManager
  3. Example Performing CRUD Operations
  4. Executing Stored Procedure
  5. EDM Relationships
  1. LINQ Queries
  2. Entity SQL Queries
  3. Lazy Loading
  4. Eager Loading
  5. Explicit Loading
  6. No-Tracking Queries
  1. Inheritance Type
    1. Table Per Type inheritance
    2. Table Per Hierarchy inheritance
  2. Modeling Techniques
    1. Database First
    2. Model First
    3. Code First
  1. What is Entity Framework
  2. EF Architecture
  3. Comparing EF with LinQ to SQL
  4. First EF Application
  1. Database First
  2. Model First
  3. Code First
  1. Creating EDMX File
  2. Life Cycle to Understand CRUD Operations
  3. ObjectStateManager
  4. Executing Stored Procedure
  5. Table Per Type inheritance
  6. Table Per Hierarchy inheritance
  1. One to One
  2. One to Many
  3. Many to Many
  4. Lazy Loading
  5. Early Loading
  6. Navigation Properties
  1. LINQ Queries
  2. Entity Queries
  3. Object Query
  4. Query Builder Syntax
  5. Debugging Queries
  6. Query Returning Anonymous Objects
  7. Parameterized Queries
Post an Enquiry

Post an Enquiry

Address

1/583, ECR, KOTTIVAKKAM
CHENNAI / TAMIL NADU / INDIA

E-mail

astroinfo@astrotech.in
astroeq.com@gmail.com

Contact No.

+91 9710107874
(044) 438 55 773