Getting Started with LINQ

Course details

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.

• Topic T2 Objective O3
• start the course
• Topic T6 Objective O7
• use LINQ in Microsoft .NET applications
• Topic T10 Objective O11
• use LINQ to query a simple list of objects in the .NET framework
• Topic T14 Objective O15
• use LINQ to create result objects from a query
• Topic T19 Objective O20
• join sets of objects with LINQ
• Topic T23 Objective O24
• access related tables in a database by using the relations defined in the data model
• Topic T27 Objective O28
• iterate over related tables in a SQL query
• Topic T31 Objective O32
• use multiple from clauses and the orderby clause and return unnamed result properties
• Topic T35 Objective O36
• use the where clause to create logical relationships between tables
• Topic T40 Objective O41
• make a change in the database that is persisted to SQL
• Topic T44 Objective O45
• create an object in an entity data model and persist that change to the SQL database
• Topic T48 Objective O49
• 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
• Topic T53 Objective O54
• control when a query is executed in LINQ
• Topic T57 Objective O58
• restrict some LINQ queries with the where clause and compose complex where parameters
• Topic T61 Objective O62
• convert a complex LINQ query to the Method Syntax
• Topic T65 Objective O66
• avoid or handle query conflicts in LINQ