Home   Technology Courses   Management Courses   Certification   MyHistory  Course Schedule   Free Catalog   About Us   What's New   Contest   Contact Us Photo Galary

Programming LINQ with Visual Basic Extended Features 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 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 , "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   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

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha