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 22s
    In this video, learn how to use LINQ in Microsoft .NET applications. FREE ACCESS
  • 4m
    In this video, you will learn how to use LINQ to query a simple list of objects in the .NET framework. FREE ACCESS
  • Locked
    3.  Using LINQ to Create Result Objects from a Query
    3m 44s
    In this video, you will learn how to use LINQ to create result objects from a query. FREE ACCESS
  • Locked
    4.  Joining Sets of Objects with LINQ
    4m 44s
    This video will show you how to join sets of objects using LINQ. FREE ACCESS
  • Locked
    5.  Retrieving Related Objects with an Entity Model
    2m 23s
    In this video, find out how to access related tables in a database by using the relations defined in the data model. FREE ACCESS
  • Locked
    6.  Iterating over Related Tables in an Entity Model
    3m 38s
    In this video, you will iterate over related tables in a SQL query. FREE ACCESS
  • Locked
    7.  Creating a Cross Product Result
    3m 27s
    During this video, you will learn how to use multiple from clauses and the orderby clause and return unnamed result properties. FREE ACCESS
  • Locked
    8.  Writing Queries to Create Relationships
    3m 46s
    In this video, you will learn how to use the WHERE clause to create logical relationships between tables. FREE ACCESS
  • Locked
    9.  Updating Values with a Query
    3m 12s
    In this video, learn how to make a change in the database that is saved in SQL. FREE ACCESS
  • Locked
    10.  Inserting Rows into a Table
    3m 38s
    In 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
  • Locked
    11.  Deleting Rows from a Table
    3m 26s
    In 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
  • Locked
    12.  Deferred Execution of a Query
    4m 31s
    In this video, you will learn how to control when a query is executed using LINQ. FREE ACCESS
  • Locked
    13.  Restricting Query Results
    4m 27s
    In this video, you will restrict some LINQ queries with the where clause and compose complex where parameters. FREE ACCESS
  • Locked
    14.  Writing Queries with the Method Syntax
    4m 38s
    In this video, you will convert a complex LINQ query to the Method Syntax form. FREE ACCESS
  • Locked
    15.  Submitting a Query and Handling Conflicts
    4m 20s
    In 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.

YOU MIGHT ALSO LIKE

Book Practical Entity Framework: Database Access for Enterprise Applications
Book Getting Started with Advanced C#: Upgrade Your Programming Skills
Book Practical Entity Framework Core 6: Database Access for Enterprise Applications, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Developing Azure & Web Services: IIS & Web Services
Course Entity Framework & LINQ to Entities
Course T-SQL Queries