Getting Started with LINQ
Visual Studio 2013
| Intermediate
- 15 Videos | 58m 15s
- Earns a Badge
LINQ provides a powerful set of tools for incorporating databases into .NET applications. Learn to create a simple query in LINQ, create relationships with a query, update database tables with a query, and some advanced query techniques.
WHAT YOU WILL LEARN
-
use LINQ in Microsoft .NET applicationsuse LINQ to query a simple list of objects in the .NET frameworkuse LINQ to create result objects from a queryjoin sets of objects with LINQaccess related tables in a database by using the relations defined in the data modeliterate over related tables in a SQL queryuse multiple from clauses and the orderby clause and return unnamed result propertiesuse the where clause to create logical relationships between tables
-
make a change in the database that is persisted to SQLcreate an object in an entity data model and persist that change to the SQL databasecheck 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 databasecontrol when a query is executed in LINQrestrict some LINQ queries with the where clause and compose complex where parametersconvert a complex LINQ query to the Method Syntaxavoid or handle query conflicts in LINQ
IN THIS COURSE
-
1.Using LINQ in Microsoft .NET Applications4m 22sUP NEXT
-
2.Using LINQ to Query a Simple List of Objects4m
-
3.Using LINQ to Create Result Objects from a Query3m 44s
-
4.Joining Sets of Objects with LINQ4m 44s
-
5.Retrieving Related Objects with an Entity Model2m 23s
-
6.Iterating over Related Tables in an Entity Model3m 38s
-
7.Creating a Cross Product Result3m 27s
-
8.Writing Queries to Create Relationships3m 46s
-
9.Updating Values with a Query3m 12s
-
10.Inserting Rows into a Table3m 38s
-
11.Deleting Rows from a Table3m 26s
-
12.Deferred Execution of a Query4m 31s
-
13.Restricting Query Results4m 27s
-
14.Writing Queries with the Method Syntax4m 38s
-
15.Submitting a Query and Handling Conflicts4m 20s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.