forum

Home / DeveloperSection / Forums / How to get entities from multiple tables with one LINQ call?

Ask Question
Utpal Vishwas

Utpal Vishwas

Follow
I am Utpal Vishwas from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

06-Sep-2023

You can get entities from multiple tables with a single LINQ call using the Include operator. You can load related entities from another table into the current entity using the include operator.

The syntax for Include operator is as follows:

from entity in source
include relatedEntity

where entity is the name of the entity loading the related entitiy and relatedEntity is the name of the related entity.

For example, the following code retrieves all the customers and their orders in a single LINQ call:

from customer in Customers
include customer.Orders

This code will first load all the customers from the Customers table. Then load all the orders for each customer from the Orders table.

You can also load multiple related entities in a single LINQ call using the include operator. For example, the following code gets all the customers, their orders, and the products that they ordered in a single LINQ call:

from customer in Customers
include customer.Orders
include customer.Orders.Products

This code will first loads all the customers from the Customers table. Then, load all the orders of each customer from the Orders table. Finally, all the products ordered by each customer are loaded from the Products table.

MindStick Training

Liked By