Microsoft LINQ Using C# 2010

  1. Technical
  2. Microsoft Technical
  3. Visual Studio
  4. Visual Studio 2010
  5. Microsoft LINQ Using C# 2010

3 Days

$0
or FREE WITH SATVs (?)

In this course, students will learn to use the Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you’ll learn about the language features for Visual C# in Visual Studio 2010 in order to make LINQ possible. You’ll start by working through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you’ve completed the course, you’ll have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.

Introduction to LINQ: 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: Language Enhancements for LINQ

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

LINQ to Objects: 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: 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

More LINQ to SQL: 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: 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: 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: 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 Modfiy Data and Save Changes
  • See How to Use Stored Procedures to Modify Data
This course assumes that students have familiarity with .NET in general, and with specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2010 or .NET Framework concepts, and assumes that the student is at least familiar with all the concepts covered in the Introduction to Programming and Developing Applications with Visual Studio 2010 courses.
  • 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 initialisers, 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
INSTRUCTORS
Newton Godoy

With over 19 years of in-class training experience and over 21 ...

REGISTER NOW

Registration of Interest

Course has been added to your shopping cart.

Microsoft LINQ Using C# 2010
Free Course Guide

Please choose which format you wish to download:
Start Download

By providing us with your email, you agree to the terms of our Privacy policy.

Success!

We've sent you an email to with the download links for your selected course guides.

Be sure to check your junk mail folder, just in case your mailbox didn't like our email!


Thanks
Your friends @ New Horizons

About Microsoft On-Demand Learning

Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.

MOC On-Demand at a Glance

Self-Paced Learning

The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.

Immediate Feedback on Mastery

Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.

SATV Eligible

Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)

Direct From the Source

MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).

Learn Anywhere Anytime

The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.

Live Hands-on
Labs

Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.

About OLLAnywhere

New Horizons’ OLLAnywhere is a revolutionary training delivery method that allows students to attend live instructor-led training from anywhere in Australia.

This Virtual Instructor Led Training (VILT) model allows students to experience the same award-winning training from expert instructors, access hands-on labs and use authorised vendor courseware, all from a remote location.

Gone are the days of having to travel long distances to attend training; now we bring the training to you!

Top 3 benefits of OLLAnywhere:

  • Learn from the convenience of your work, home or nearest New Horizons location
  • Gain remote access to LIVE, instructor-led training from industry certified trainers
  • Connect virtual teams for collaborative group learning.
Learn More ...
top

OLLAnywhere is a revolutionary way of utilising cutting-edge technology to allow students to attend live instructor-led training from anywhere in or outside of Australia.