Microsoft LINQ Using Visual Basic 2008

Course:   LINQVB
Duration:   2 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/LINQVB.html
 
Course Summary

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 Basic 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 not only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.

Topics Covered In This Course

Introduction to LINQ

  • Language Integrated Query
  • Structure of a LINQ Query
  • Some LINQ Examples

Language Enhancements for LINQ

  • LINQ and Languages
  • Implicity Typed Local Variables and Object Initializers
  • Lambda Expressions, Extension Methods, and Anonymous Types

LINQ to Objects

  • Using LINQ with in-Memory Collections
  • LINQ Operations and Extension Methods

LINQ to SQL

  • LINQ and Relational Data
  • Creating an Object Model
  • Querying Data
  • Modifying Data
  • Using Stored Procedures
  • LINQ to SQL vs. DataSets

More LINQ to SQL

  • LINQ to SQL Advanced Features
  • Using LINQ to SQL in a Windows Application
  • Using LINQ to SQL in a Web Application

LINQ to DataSet

  • Review of DataSets
  • Querying Data with LINQ to DataSet
  • LINQ to DataSet and DataViews
  • Binding to Data

LINQ to XML

  • Create and Manipulating XML Content
  • Using LINQ to Query XML Content
  • Transforming XML Using LINQ

LINQ to Entities

  • Overview of Entry Framework
  • Creating an Entity Data Model
  • Querying Data
  • Modify Data
  • Using Stored Procedures

What You Can Expect

At the end of this course, delegates will be able to:

  • 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 initializers, 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.
What You Can Expect

At the end of this course, delegates will be able to:

Who Should Take This Course

.NET and ADO.NET developers

Recommended Prerequisites

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 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.

Training Style

Instructor-led course (75%) with labs (25%).

Related Courses
Code Course Title Duration Level
VBNWF
Visual Basic .NET Programming and WinForm Applications
5 Days
I
Details
VBADV
Enterprise Development In Visual Basic .NET
3 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.