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 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.
- 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 Implicit Type Declaration
- Use Object Initialisation
- 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
- 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
- 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
- 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
Newton Godoy
With over 19 years of in-class training experience and over 21 ...
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.