• Online, Self-Paced
Course 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.

Learning Objectives

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.