Microsoft LINQ Using VB 2008 Course

Topics covered on the 2 day Microsoft LINQ Using VB 2008 course

Introducing LINQ

• Language Integrated Query
• Data Access, Historically
• LINQ to the Rescue
• LINQ Providers
• Structure of a LINQ Query
• The Three Stages of a LINQ Query
• Returning Multiple Values
• Deferred Execution

Language Extensions for LINQ

• LINQ and Languages
• Implicitly Typed Local Variables and Object Initializers
• Implicit Type Declarations
• Object Initializers
• Lambda Expressions, Extension Methods, and Anonymous Types
• Lambda Expressions
• Extension Methods
• Anonymous Types

LINQ to Objects

• Using LINQ with In-Memory Collections
• What Can You Query?
• Arrays
• Generic Lists
• Generic Dictionaries
• Strings
• Other Collections (Non-Generic Collections)
• LINQ Operators and Extension Methods
• Working with Data
• Creating Sequences
• Selecting Sequences
• Retrieving a Single Element
• Filtering Sequences
• Ordering Sequences
• Verifying Sequences
• Converting Sequences
• Positioning within Sequences
• Calculating Sequences
• Set Operations

LINQ to SQL

• LINQ and Relational Data
• Creating an Object Model
• The DataContext Class
• Entity Classes
• Associations Between Entities
• Querying Data
• Simple Queries
• Scalar Functions
• Aggregate Functions
• Querying Related Tables
• Lambda Expressions
• Extension Methods
• Grouping
• Joins
• Modifying Data
• Using Stored Procedures
• Configuring the Update Behavior of Entity Classes
• LINQ to SQL vs. DataSets

More LINQ to SQL

• LINQ to SQL Advanced Features
• Deferred Loading
• Read-Only Queries
• Compiled Queries
• Direct Execution of Queries
• Transactions
• Cascading Deletes
• Tracking Changes
• Creating and Deleting Databases
• Validating Data
• Using LINQ to SQL in a Windows Applications
• Exploring the Data Layer
• Exploring the User Interface
• Using LINQ to SQL in a Web Application
• Working with Customers
• Working with Orders
• Working with Products

LINQ to DataSet

• Review of DataSets
• Retrieving and Modifying Data
• Querying Data with LINQ to DataSet
• Querying Data in Tables
• Querying Tables in Untyped DataSets
• Querying Tables in Typed DataSets
• LINQ to DataSet and DataViews
• Binding to Data
• Convert Query Results to a List
• Copy Query Results to a DataTable
• Create a DataView from Query Results

LINQ to XML

• Creating and Manipulating XML Content
• Creating XML Content
• Traversing XML
• Updating XML Content
• Verifying XML Content Using a Schema
• Using LINQ to Query XML Content
• Simple LINQ Queries
• Anonymous Types in LINQ to XML
• Using Extension Methods with LINQ to XML
• LINQ to XML and Lambda Expressions
• Transforming XML Using LINQ
• Creating New Output
• Filling in the Details
• Using Visual Basic’s Replacement Tokens

LINQ to Entities

• Overview of the Entity Framework
• Creating an Entity Data Model
• The ObjectContext Class
• Entity Classes
• Associations Between Entities
• Querying Data
• Simple Queries
• Scalar Functions
• Aggregate Functions
• Querying Related Tables
• Lambda Expressions
• Grouping
• Joins
• Differences Between LINQ to Entities and LINQ to SQL
• Modifying Data
• Using Stored Procedures
• Configuring the Update Behavior of Entity Classes