O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft LINQ

Video Description

Language Integrated Query is a new programming feature set that Microsoft officially introduced as part of the 3.5 release version of the .NET Framwork. LINQ brings the world of data queries into the .NET Framework and makes the query itself part of the development environemnt. The result is that developers can now access data from diverse sources using queries with very similar syntax. LINQ provides Intellisense, compiler hints and assistance as well as making data queries happen with few lines of code that is easier to read and understand.

In this course, Mark Long introduces you to the basics of LINQ. He shows you how to get started with LINQ, how LINQ works and with lots of programming demos, he takes you step by step through using LINQ to query Objects, SQL Server and XML documents. To begin learning today, simply click on the movie links.

Table of Contents

  1. Introduction to Microsoft LINQ
    1. Welcome 00:01:52
    2. Course Overview 00:05:14
    3. What is LINQ? 00:04:39
    4. Why Do We Need LINQ? 00:05:34
    5. How LINQ Works 00:06:27
    6. LINQ Implementations 00:06:29
    7. LINQ Architecture 00:05:08
    8. LINQ Requirements 00:06:23
    9. LINQ to Reality 00:04:09
    10. Course Setup 00:04:15
    11. Managing SQL Server Express 00:06:22
    12. Managing SSE Demo 00:07:25
  2. Getting Ready For LINQ
    1. LINQ Requirements 00:03:40
    2. New Features in C# & VB.NET 00:02:13
    3. Implicitly Typed Variables 00:03:17
    4. Implicitly Typed Variables Demo 00:03:59
    5. Object Initializers 00:02:35
    6. Object Initializer Demo 00:06:12
    7. Anonymous Types 00:04:43
    8. Anonymous Types Demo 00:05:18
    9. Extension Methods 00:02:50
    10. Extension Methods Demo 00:06:21
    11. Lambda Expressions 00:06:34
    12. Lamda Expression Demo 00:06:55
  3. LINQ Basics
    1. Basic VB.NET LINQ pt. 1 00:06:11
    2. Basic VB.NET LINQ pt. 2 00:04:45
    3. Code Explanation 00:05:30
    4. LINQ Queries 00:06:19
  4. LINQ to SQL
    1. LINQ to SQL Basics 00:06:33
    2. Object Relational Mapping 00:07:32
    3. Using O/R Demo pt. 1 00:06:04
    4. Using O/R Demo pt. 2 00:05:20
    5. Manual Data Mapping pt. 1 00:05:58
    6. Manual Data Mapping pt. 2 00:07:24
    7. Filtering Using Expressions pt. 1 00:07:24
    8. Filtering Using Expressions pt. 2 00:06:57
    9. LINQ Joins Demo pt. 1 00:05:42
    10. LINQ Joins Demo pt. 2 00:06:15
    11. LINQ GroupBy Demo 00:07:16
    12. LINQ to SQL Insert Demo pt. 1 00:06:48
    13. LINQ to SQL Insert Demo pt. 2 00:06:54
    14. LINQ to SQL Insert Demo pt. 3 00:06:49
    15. LINQ to SQL Update Demo pt. 1 00:05:01
    16. LINQ to SQL Update Demo pt. 2 00:06:47
    17. LINQ to SQL Delete Demo 00:06:56
    18. Calling Stored Procedures 00:06:51
  5. LINQ to DataSet
    1. LINQ to DataSet Basics 00:05:59
    2. LINQ to DataSet Demo pt. 1 00:06:45
    3. LINQ to DataSet Demo pt. 2 00:06:35
  6. LINQ to XML
    1. LINQ to XML Basics 00:02:56
    2. XDocument Demo 00:07:31
    3. XElement Demo 00:05:46
    4. XComment Demo 00:06:41
    5. Attribute Demo 00:04:26
    6. XML Literals Demo 00:04:36
    7. XML Inline Variables Demo 00:03:51
    8. XML Query Demo pt. 1 00:06:35
    9. XML Query Demo pt. 2 00:06:58
  7. Conclusion
    1. Course Wrap-Up 00:06:19
  8. Credits
    1. About the Author 00:02:42