Live Help (Start Chat)
Download syllabus copy Download printable copy

Linq

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.


Linq 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.

Prerequisites

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

Linq Duration

15 Days

Linq 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
facultyImg

Sai Charan SVV

Sai Charan is an outstanding trainer,developer for MS.NET 4.5 at Deccansoft. Has In Depth know of each and every topic and delivers the same to the students.. he is Microsoft Certified in HTML5,CSS3&Java script, working as a Software Programmer for Deccansoft. more

facultyImg

Sandeep MVN

Sandeep Mvn is an excellent trainer for MS .NET Live Project with real time exposure and trains the students to upgrade their skills in all aspects of working with a real time project. His uniqueness lies in conducting the classes with ease and clarity. more

facultyImg

Suresh K

Suresh is an excellent trainer for MS .NET Live Project with real time exposure and trains the students to upgrade their skills in all aspects of working with a real time project. he is also a trainer for MS.NET. His uniqueness lies in conducting the classes with ease and clarity. more

facultyImg

Vishwaraj

Vishwaraj is an excellent trainer for MS .NET Live Project with real time exposure and trains the students to upgrade their skills in all aspects of working with a real time project. he is also a trainer for MS.NET. more

Post an Enquiry

Name
Email Id
Contact No
Course
Details
Scroll to Top