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 applications
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
Convert a complex linq query to the method syntax
Avoid or handle query conflicts in linq
IN THIS COURSE
-
4m 22sIn this video, learn how to use LINQ in Microsoft .NET applications. FREE ACCESS
-
4mIn this video, you will learn how to use LINQ to query a simple list of objects in the .NET framework. FREE ACCESS
-
3. Using LINQ to Create Result Objects from a Query3m 44sIn this video, you will learn how to use LINQ to create result objects from a query. FREE ACCESS
-
4. Joining Sets of Objects with LINQ4m 44sThis video will show you how to join sets of objects using LINQ. FREE ACCESS
-
5. Retrieving Related Objects with an Entity Model2m 23sIn this video, find out how to access related tables in a database by using the relations defined in the data model. FREE ACCESS
-
6. Iterating over Related Tables in an Entity Model3m 38sIn this video, you will iterate over related tables in a SQL query. FREE ACCESS
-
7. Creating a Cross Product Result3m 27sDuring this video, you will learn how to use multiple from clauses and the orderby clause and return unnamed result properties. FREE ACCESS
-
8. Writing Queries to Create Relationships3m 46sIn this video, you will learn how to use the WHERE clause to create logical relationships between tables. FREE ACCESS
-
9. Updating Values with a Query3m 12sIn this video, learn how to make a change in the database that is saved in SQL. FREE ACCESS
-
10. Inserting Rows into a Table3m 38sIn this video, you will learn how to create an object in an entity data model and persist that change to the SQL database. FREE ACCESS
-
11. Deleting Rows from a Table3m 26sIn this video, you will 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. FREE ACCESS
-
12. Deferred Execution of a Query4m 31sIn this video, you will learn how to control when a query is executed using LINQ. FREE ACCESS
-
13. Restricting Query Results4m 27sIn this video, you will restrict some LINQ queries with the where clause and compose complex where parameters. FREE ACCESS
-
14. Writing Queries with the Method Syntax4m 38sIn this video, you will convert a complex LINQ query to the Method Syntax form. FREE ACCESS
-
15. Submitting a Query and Handling Conflicts4m 20sIn this video, you will learn how to avoid or handle query conflicts in LINQ. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
