|
|
Class Outline*
|
|
| Request Info | Contact Us |
|
Microsoft LINQ
Duration:
2 Days
Overview:
In this course, you'll learn to use the exciting new .NET Framework 3.5 feature Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you'll learn about the new language features added to Visual C# in Visual Studio 2008 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 how to construct LINQ queries to work with data and also how to use the features added to Visual Basic that support LINQ.
Prerequisites
This course assumes that students have familiarity with .NET in general and specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2008 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 2008 courses.
For additional reading to help you prepare for this class, you could review the following resources:
- Silverlight Resource Site (http://www.silverlight.net)
- MSDN Articles. Search terms: XAML, WPF, HTML (http://msdn.microsoft.com)
|
|
Outline:
|
Lesson 1: 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
|
|
Lesson 2: 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
|
|
Lesson 3: 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
|
|
Lesson 4: 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 an SQL Server Database
- Explore How to Modify Data and Save Changes
- See How to Use Stored Procedures to Modify Data
|
|
Lesson 5: 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
|
|
Lesson 6: 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
|
|
Lesson 7: 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
|
|
Lesson 8: 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
|
|
|
| |
*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.
|