Getting Started with LINQ

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

Prerequisite
None

Expected Duration
66 minutes

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.

Objective

Creating a Simple Query

  • 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

Creating Relationships with 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

Updating a Database with a Query

  • 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

Advanced Queries

  • 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.