Getting Started with LINQ from Skillsoft

Online, Self-Paced

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

Design and Development

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):