Getting Started with LINQ

Overview/Description
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

Prerequisites
None

Expected Duration (hours)
1.0

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