LinQ Course Details

The acronym LINQ is for Language Integrated Query. Microsoft’s query language is fully integrated and offers easy data access from in-memory objects, databases, XML documents and many more. It is through a set of extensions, LINQ ably integrate queries in C# and Visual Basic.

Syllabus:

 C# Language Extension3.5 (Prerequisite)
• Type Inference
• Object Initializers
• Anonymous Types
• Extension Methods
• Partial Methods
 LINQ Architecture
• Understanding the LINQ Framework
• LINQ Provider
o LINQ to Object
o LINQ to SQL
o LINQ to Dataset
o LINQ to XML
 LINQ to Object
• IEnumerable <T> and IQueryable<T> interface
• System.LINQ namespace
• Query Expressions
• Lambda Expressions
• Using Custom Class Collection
 LINQ to SQL
• Defining the Data Model class
• Using Mapping attributes
• Using the Data Context class
• Defining Relationships using Associations
• Creating a customized Data Context class
• LINQ to SQL Designer(DBML File)
• Performing Add/Edit/Delete/View Operations
• Tracking changes to entities
• Submitting changes
• Concurrency error handling issues
• Join Query
• Validating Entities
• Transaction Handling
• Executing Stored Procedure
• LINQ to SQL architecture
 LINQ to XML
• Understanding the LINQ to XML Class hierarchy
• Create an XML document
• Loading existing XML document
• Querying XML using LINQ to XML
• Manipulating XML
o Adding nodes
o Modifying nodes
o Deleting nodes
 LINQ to Dataset
• Querying Datasets
• Querying typed Datasets
• Using LINQ over Dataset with Table Adapter

Last modified: Sunday, 31 July 2016, 11:14 PM