Using LINQ and XML with ADO.NET 4 and Visual Basic 2010


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
The .NET Language-Integrated Query (LINQ) provide developers common query language within ADO.NET applications, minimizing the amount of code required. This course explores the various ways you can use LINQ to develop and optimize data applications. Specific topics covered include LINQ to DataSet, LINQ to SQL and LINQ to Entities queries. The course also explores how XML data can be accessed and manipulated using ADO.NET applications, including coverage of LINQ to XML queries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.

Target Audience
All organizations or individual consultants who are building or intend to build .NET Framework 4 applications with ADO.NET, Visual Studio 2010, and Visual Basic 2010; corporate employees, consultants, and university or college students who are preparing for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516.

Prerequisites
Thorough knowledge of software-development concepts and the process of building business applications; experience building applications with the Microsoft .NET Framework; working experience of Visual Studio 2010 and Visual Basic 2010

Expected Duration (hours)
1.5

Lesson Objectives

Using LINQ and XML with ADO.NET 4 and Visual Basic 2010

  • match the three ADO.NET LINQ technologies to their descriptions
  • recognize how to use the language features supported by LINQ
  • recognize the code used to perform different LINQ to DataSet queries
  • recognize how to create a LINQ to SQL query
  • recognize the steps for creating and executing a LINQ to Entities query
  • use XmlReader
  • use XPathDocument to query XML data
  • query XML with LINQ
  • write a LINQ to DataSet query
  • write a LINQ to SQL query
  • write a LINQ to Entities query
  • use LINQ to query XML
  • Course Number:
    sd_advb_a08_it_enus