Microsoft LINQ Using Visual Basic 2010, Part 3 of 4

Course description

In this course, you will learn to use the Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you will learn about the language features for Visual Basic in Visual Studio 2010 in order to make LINQ possible. You will start by working through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you have completed the course, you will have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course assumes that students have familiarity with .NET in general, and with specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2010 or .NET Framework concepts, and assumes that the student is at least familiar with all the concepts covered in the Introduction to Programming and Developing Applications with Visual Studio 2010 courses.

Meet the experts

Ken Getz

Ken Getz is a featured instructor for several of our Visual Studio courses. He is a Visual Basic and Visual C# expert and has been recognized multiple times as a Microsoft MVP. Ken is a seasoned instructor, successful consultant, and the author or co-author of several best-selling books. He is a frequent speaker at technical conferences like Tech-Ed, VSLive, and DevConnections and he has written for several of the industry's most-respected publications including Visual Studio Magazine, CoDe Magazine, and MSDN Magazine.

Robert Green

Robert Green is a Visual Studio expert and a featured instructor for several of our Visual Basic and Visual C# courses. He is currently a Technical Evangelist in the Developer Platform and Evangelism (DPE) group at Microsoft. He has also worked for Microsoft on the Developer Tools marketing team and as Community Lead on the Visual Basic team. Robert has several years of consulting experience focused on developer training and is a frequent speaker at technology conferences including TechEd, VSLive, VSConnections, and Advisor Live.

Video Runtime

133 Minutes

Time to complete

173 Minutes

Course Outline

Module 5

LINQ to SQL Advanced Features (48:30)

• Introduction (00:42)
• Deferred Execution (00:49)
• Deferred Loading (02:45)
• Read Only Queries (00:37)
• Compiled Queries (00:46)
• Direct Execution of Queries (00:53)
• Demo: Deferred Loading (06:24)
• Demo: Compiled Queries (06:39)
• Transactions (02:07)
• Cascading Deletes (00:50)
• Tracking Changes (01:29)
• Creating Databases (01:27)
• Demo: Transactions (12:08)
• Data Validation (01:39)
• Demo: Data Validation (08:24)
• Summary (00:44)

LINQ to SQL Applications (28:06)

• Introduction (00:31)
• Overview (00:54)
• Web Application (00:28)
• LinqDataSource Control (01:19)
• Demo: Win App (13:51)
• Demo: Web App (10:19)
• Summary (00:41)

Module 6

Querying Data (35:26)

• Introduction (00:37)
• DataSets (01:39)
• Working with Data (01:23)
• LINQ to DataSet (01:00)
• Querying on DataSets (00:35)
• Untyped DataSets (01:53)
• Typed DataSets (01:04)
• Demo: Querying Data (18:48)
• Filter, Sort and Find (00:50)
• DataViews (00:38)
• Demo: DataViews (06:26)
• Summary (00:29)

Data Binding (21:50)

• Introduction (00:33)
• Overview (00:34)
• ToList (00:39)
• CopyToDataTable (00:54)
• AsDataView (01:04)
• Demo: Data Binding (17:39)
• Summary (00:22)