Course details

Getting Started with LINQ

Getting Started with LINQ

Target Audience
Expected Duration
Lesson Objectives
Course Number

LINQ is a set of features added to C# and VB to enable querying of collections, databases, and XML documents. LINQ provides a powerful and simple set of tools for incorporating databases into your .NET applications. This course covers creating a simple query in LINQ, creating relationships with a query, updating database rows and tables with a query, and finally some advanced query techniques.

Target Audience
Microsoft .NET developers writing applications to query data sources with LINQ


Expected Duration (hours)

Lesson Objectives

Getting Started with LINQ

  • start the course
  • use LINQ in Microsoft .NET applications
  • use LINQ to query a simple list of objects in the .NET framework
  • use LINQ to create result objects from a query
  • join sets of objects with LINQ
  • access related tables in a database by using the relations defined in the data model
  • iterate over related tables in a SQL query
  • use multiple from clauses and the orderby clause and return unnamed result properties
  • use the where clause to create logical relationships between tables
  • make a change in the database that is persisted to SQL
  • create an object in an entity data model and persist that change to the SQL database
  • check if an object exists in an entity data model, remove existing relationships to other data objects, and then remove it from the data model and the SQL database
  • control when a query is executed in LINQ
  • restrict some LINQ queries with the where clause and compose complex where parameters
  • convert a complex LINQ query to the Method Syntax
  • avoid or handle query conflicts in LINQ
  • Course Number: