Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

Programming Visual Basic® Extended Features: Hands-On
Building Data-Centric Applications with LINQ

Course: 974   Type: Hands-On   Duration: 4 Days
Quick Enrol  

You Will Learn How To

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

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
Experienced Visual Basic programmers who want to improve their software development capabilities by using the new and 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 new 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 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 New .NET 3.5 Visual Basic Language Features
Language constructs
  • Applying auto-implemented properties
  • Benefiting from implied-type declaration
Simplifying code
  • Instantiating entity objects
  • Comparing constructors with object initialisers
  • Alternative object initialisation
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
  • DataSet objects vs. generic lists
  • SqlDataReader vs. IEnumerable<T>
  • Processing data-tier information
Connecting to and reading from a database
  • Specifiying a connection string
  • 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
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 orderby constraints
Applying extended features
  • Making code more flexible with delegates
  • Sorting with delegates
  • Streamlining code with anonymous types
Processing Data with LINQ Queries
Manipulating data
  • Selecting data from multiple sources with selectmany
  • 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, intersect and accept
  • Collating with group by
  • Creating hierarchical data structures with groupjoin
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
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
Visual Basic is a registered trademark of Microsoft Corporation.
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
Programming Visual Basic Extended Features
Course Schedule
12 - 15 Aug, 2008
London
28 - 31 Oct, 2008
London
20 - 23 Jan, 2009
London

Participants applying extended Visual Basic features.

£ 1,695 - Standard Tuition
Savings Plans
£ 1,080 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 1,215 - 10-Training Vouchers
£ 1,300 - 5-Training Vouchers
£ 1,525 - Alumni Gold Tuition

 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610