Linq

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Language Integrated Query is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript.LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources. Other uses, which utilize query expressions as a general framework for readably composing arbitrary computations, include the construction of event handlers or monadic parsers.

At the end of the training, participants will be able to:

Pre-requisite

Students must be having knowledge of C# programming language and basic knowledge of SQL Server.

Duarion

5 days

Course Outline

  1. Motivate the Need for LINQ
  2. Learn about the Various LINQ Providers
  3. Investigate Simple LINQ to Objects, LINQ to SQL, and LINQ to XML Samples
  1. Investigate the New Language Features Required by LINQ
  2. Learn about Implicit Type Declaration
  3. Use Object Initialization
  4. Work with Lambda Expressions
  5. Create and Use Extension Methods
  6. Select Multiple Columns Using Anonymous Types
  1. Learn Various Techniques for Using LINQ to Query Collections of In-Memory Objects
  2. Use LINQ with Arrays, Generic Lists, Generic Dictionaries, Strings, and Other Non-Generic Collections
  3. Work with Examples Using Many of the System.Linq.Enumerable Extension Methods, and Compare these Methods to LINQ Keywords
  1. Learn How to Map a Data Model to an Object Model
  2. Lean Various Techniques for Using LINQ to SQL to Query Data in a SQL Server Database
  3. Explore How to Modify Data and Save Changes
  4. See How to Use Stored Procedures to Modify Data
  1. Explore Advanced Features of LINQ to SQL
  2. Explore Using LINQ to SQL in a Windows Application
  3. Explore Using LINQ to SQL in a Web Application
  1. Learn Various Techniques for Using LINQ to DataSet to Query Data in a DataSet
  2. See How to Use DataViews with the Results of a LINQ to DataSet Query
  3. Explore How to Bind the Results of a LINQ to DataSet Query to Windows Forms Controls
  1. Create XML Content Using Classes in the System.Xml.LINQ Namespace
  2. Search Content Using XPath Expressions with the LINQ-Based API
  3. Validate XML Content Using the LINQ-Based API
  4. Query XML Content Using LINQ to XML
  5. Transform XML Content Using LINQ to XML
  1. Understand the Relationship Between LINQ to Entities and the Entity Framework
  2. Learn How to Map a Data Model to an Entity Data Model
  3. Learn Various Techniques for Using LINQ to Entities to Query Data in a Database
  4. Explore How to Modify Data and Save Changes
  5. See How to Use Stored Procedures to Modify Data

Reviews