LINQ Training: Introduction to Language Integrated Query (LINQ) C#

Course Number: LNQ-200
GSA/Previous Course Number: 892
Duration: 2 days
view class outline

LINQ Training Overview

Accelebrate's Introduction to LINQ training classes teaches attendees how to use Language Integrated Query to query arrays, enumberable classes, relational databases, and a wide variety of other relational and object-based data sources.

NOTE: Accelebrate also offers Introduction to LINQ training for VB.NET.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/microsoft.htm.

LINQ Training Prerequisites

Prior experience developing applications in .NET 1.1 or 2.0 using C# or VB.NET.

Hands-on/Lecture Ratio

This LINQ training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 20 minutes.

LINQ Training Materials

All LINQ training students receive more than 200 pages of comprehensive courseware and a related textbook.

Software Needed on Each Student PC

Windows XP with at least 1GB RAM or Windows Vista or 7 with at least 2GB RAM
Visual Studio 2008 or 2010, with the latest service packs and with SQL Server Express enabled
If you have purchased this class, please contact us for more detailed setup specifications

LINQ Training Objectives

Create new XML content using LINQ to XML.
Iterate through collections of objects, using a single LINQ query.
Use anonymous types, lambda expressions, extension methods, object initializers, and implicit type declaration.
Query arrays, lists, dictionaries, and more using LINQ to Objects.
Use the extension methods provided by the System.Linq.Enumerable class to extend the behavior of collection classes.
Create an object model based on a SQL Server database and then query the database using LINQ to SQL.
Modify data and use stored procedures with LINQ to SQL.
Create XML content using classes in the System.Xml.Linq namespace.
Validate, query and transform XML content using LINQ to XML.
Transform XML content using LINQ to XML.
Create an Entity Data Model based on a data source and then query the data using LINQ to Entities.
Modify data and use stored procedures with LINQ to Entities.

LINQ Training Outline

Introduction to LINQ

Motivate the Need for LINQ
Learn about the Various LINQ Providers
Investigate Simple LINQ to Objects, LINQ to SQL, and LINQ to XML Samples

Language Enhancements for LINQ

Investigate the New Language Features Required by LINQ
Learn about Implicit Type Declaration
Use Object Initialization
Work with Lambda Expressions
Create and Use Extension Methods
Select Multiple Columns Using Anonymous Types

LINQ to Objects

Learn Various Techniques for Using LINQ to Query Collections of In-Memory Objects
Use LINQ with Arrays, Generic Lists, Generic Dictionaries, Strings, and Other Non-Generic Collections
Work with Examples Using Many of the System.Linq.Enumerable Extension Methods, and Compare these Methods to LINQ Keywords

LINQ to SQL

Learn How to Map a Data Model to an Object Model
Lean Various Techniques for Using LINQ to SQL to Query Data in a SQL Server Database
Explore How to Modify Data and Save Changes
See How to Use Stored Procedures to Modify Data

More LINQ to SQL

Explore Advanced Features of LINQ to SQL
Explore Using LINQ to SQL in a Windows Application
Explore Using LINQ to SQL in a Web Application

LINQ to DataSets

Learn Various Techniques for Using LINQ to DataSet to Query Data in a DataSet
See How to Use DataViews with the Results of a LINQ to DataSet Query
Explore How to Bind the Results of a LINQ to DataSet Query to Windows Forms Controls

LINQ to XML

Create XML Content Using Classes in the System.Xml.LINQ Namespace
Search Content Using XPath Expressions with the LINQ-Based API
Validate XML Content Using the LINQ-Based API
Query XML Content Using LINQ to XML
Transform XML Content Using LINQ to XML

LINQ to Entities

Understand the Relationship Between LINQ to Entities and the Entity Framework
Learn How to Map a Data Model to an Entity Data Model
Learn Various Techniques for Using LINQ to Entities to Query Data in a Database
Explore How to Modify Data and Save Changes
See How to Use Stored Procedures to Modify Data

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

LINQ Training: Introduction to Language Integrated Query (LINQ) for C#