1-800-THE-TREE (1-800-843-8733)
 

Programming LINQ with Visual Basic 2008: Hands-On

Building Data-Centric Applications

 
Course: 974     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

You Will Learn How To
  • Develop data-centric Visual Basic applications with LINQ
  • Exploit Language INtegrated Query (LINQ) to integrate diverse data sources
  • Map objects to relational data sources
  • Manipulate, filter and group data using LINQ queries
  • Parse and create XML documents with LINQ
  • Leverage VB to write stored procedures

Course Benefits
With the introduction of .NET 3.5 extended features, including LINQ, Visual Basic has evolved into a full data-manipulation language. .NET 3.5 extended features enable programmers to overcome many of the difficulties encountered working with disparate data sources, such as relational databases, XML and object data. In this course, you learn how to apply extended features to programming problems.

Who Should Attend
Visual Basic programmers who want to improve their software development capabilities by using the extended language features, and in particular Language Integrated Query (LINQ). Visual Basic Programming experience at the level of Course 503, "Visual Basic 2008 Programming," is assumed.

Hands-On Training
Through an extensive case study, you gain experience applying VB extended features and LINQ. Exercises include:
  • Applying Visual Basic shortcut features
  • Retrieving results using LINQ queries
  • Processing objects and data to insert, update and delete with LINQ
  • Integrating in-memory objects, relational databases and XML
  • Entity-class publishing using the O/R Designer tool
  • Parsing XML documents using LINQ
  • Building stored procedures with Visual Basic

Course 974 Content
Introduction
  • Review of three-tier OO application architecture
  • Data access and data processing
  • Polymorphism
  • Inheritance
  • Encapsulation
  • Implementing to an interface
  • Working with generic collections
Adopting .NET 3.5 Visual Basic Language Features
Language constructs
  • Writing query expressions
  • Benefiting from implied-type declaration
Simplifying code
  • Instantiating entity objects
  • Comparing constructors with object initializers
  • Alternative object initialization
Writing LINQ Queries
Syntax and semantics
  • Coding LINQ queries
  • Ordering data and objects
  • Filtering data and objects using Where
Iterating collections
  • Interfacing between VB and LINQ using IEnumerable<T>
  • Converting from IEnumerable<T> to List<T>
Querying SQL with LINQ
Comparing ADO.NET with LINQ
  • DataReader vs. Generic Collections
  • Processing data-tier information
  • Building a middle tier with entity classes
Connecting to and reading from a database
  • Attaching to a database with LINQ
  • Working with table and entity classes
  • Mapping objects to relational databases with the Object Relational Designer (O/R Designer) tool
  • Creating External Maps with SQLMetal
Updating a database
  • Inserting, updating and deleting data
  • Error handling and exceptions
  • Committing and rolling back transactions
Coding Lambda Expressions and Extension Methods
Filtering and ordering data with lambda expressions
  • Constructing lambda expressions
  • Specifying Where and Order By constraints
Applying extended features
  • Making code more flexible with interfaces
  • Sorting with IComparer<T>
  • Streamlining code with anonymous types
Processing Data with LINQ Queries
Manipulating data
  • Selecting data from multiple sources with Select
  • Retrieving unique results with Distinct
  • Combining multiple results with Join
  • Aggregating with Average and Count
Filtering data
  • Limiting result sets with Take
  • Discarding results with Skip
Grouping data
  • Choosing data with Union and Concat
  • Collating with Group By
  • Creating hierarchical data structures with Group Join
Processing XML with LINQ
Accessing XML
  • Retrieving the document, elements and attributes
  • Parsing an XML document using LINQ
Integrating XML in your code
  • Creating XML directly: XML literals
  • Embedding XML literals in dynamic expressions
Implementing Stored Procedures using LINQ
Exploiting stored procedures
  • Writing stored procedures in VB
  • Calling stored procedures
Updating data via stored procedures
  • Processing data with LINQ
  • Integrating results sets
Related Courses
Visual Basic is a registered trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 45% per course with this limited offer!

Programming LINQ with Visual Basic 2008: Hands-On
See the complete schedule of classroom sessions scheduled in our training locations.
 
On-Site Training
Bring this or any Learning Tree course to your location.
 
Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,667 Training Passport
$ 1,700 Premium-Pass
$ 2,170 Triple-Pack
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Programming LINQ with Visual Basic 2008: Hands-On
Programming LINQ with Visual Basic 2008: Hands-On
Participants applying extended Visual Basic features.


Certification Core Course CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733