3 Days
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 Basic 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.
- Motivate the Need for LINQ
- Learn about the Various LINQ Providers
- Investigate Simple LINQ to Objects, LINQ to SQL, and LINQ to XML Samples
- Investigate the New Language Features Required by LINQ
- Learn about Impllicit Type Declaration
- Use Object Initialization
- Work with Lambda Expressions
- Create and Use Extension Methods
- Select Multiple Columns Using Anonymous Types
- 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
- Learn How to Map a Data Model to an Object Model
- Learn 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
- 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
- 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
- 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
- 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
Newton Godoy
With over 19 years of in-class training experience and over 21 ...
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
Immediate Feedback on Mastery
SATV Eligible
Direct From the Source
Learn Anywhere Anytime
Live Hands-on
Labs
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.