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
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