LiveZilla Live Chat Software
Download syllabus copy Download printable copy

LINQ & Entity Framework Training

Image

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. Deccansoft'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

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

Prerequisites

Working knowledge of

1.      C# and specially OOPS and Delegates.

2.      Sql-Server tables and stored procedures.


LINQ & Entity Framework Training Options

  • Regular classroom based training available for this course.
  • Fast Track(1-1): 18 hour, No of hours can be as per convenience of participant.
  • Video based online training, please visit:

http://www.bestdotnettraining.com/online-linq-training

http://www.bestdotnettraining.com/online-entityframework-training

  • Online 1-1 training please send us your request to enquiry@deccansoft.com or call  +91 4027841517 / 27815225 / 8008327000

LINQ & Entity Framework Training 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. I. LINQ to Object
    2. II. LINQ to SQL
    3. III. LINQ to Dataset
    4. IV. LINQ to XML
  1.  IEnumerable <T> and IQueryable<T> 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 Firs
    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
facultyImg

Sandeep Soni

Sandeep has 20 years of experience working in various Microsoft Technologies/Platforms incl. VB6.0, ASP, VC++, VB.NET, C#. He is involved in managing and architecting projects at Deccansoft. He will be your liaison to Deccansoft, for any kind of communication more

CEO & Trainer
Email Id
Contact No
Course
Subject
Details
Scroll to Top