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

Programming Visual Basic Extended Features: Hands-On

Building Data-Centric Applications with LINQ

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

Quick Enroll    

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 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 New .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
  • ADO.NET DataReader vs. IEnumerable<T>
  • 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
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

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 an EXTRA $200 on a 10-Day Training Pass!

Programming Visual Basic Extended Features: Hands-On
Upcoming Dates
Oct 14 - 17, 2008
 Washington, DC (Reston, VA)
Nov 18 - 21, 2008
 Chicago (Schaumburg)
Dec 2 - 5, 2008
 Toronto
Dec 2 - 5, 2008
 Washington, DC (Alexandria, VA)
Dec 9 - 12, 2008
 Los Angeles
Dec 9 - 12, 2008
 New York
Dec 16 - 19, 2008
 Ottawa
Dec 16 - 19, 2008
 Washington, DC (Rockville, MD)
Jan 20 - 23, 2009
 Washington, DC (Reston, VA)
Feb 24 - 27, 2009
 Chicago (Schaumburg)

Programming Visual Basic Extended Features: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

Programming Visual Basic Extended Features: Hands-On
Programming Visual Basic Extended Features: 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