enquiry@mymiit.com 9900996527 | 9902524178
Home > Courses > Linq

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 Syllabus

C# Language Extension3.5
  1. Type Inference
  2. Object Initializers
  3. Anonymous Types
  4. Extension Methods
  5. Partial Methods
LINQ Architecture
  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
LINQ to Object
  1.  IEnumerable <T> and IQueryable<T> interface
  2.  System.LINQ namespace
  3.  Query Expressions
  4.  Lambda Expressions
  5.  Using Custom Class Collection
LINQ to SQL
  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
LINQ to XML
  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
LINQ to Dataset
  1.  Querying Datasets
  2.  Querying typed Datasets
  3.  Using LINQ over Dataset with Table Adapter

Post an Enquiry

Name
Email Id
Contact No
Course
Details
);
Scroll to Top