I would like to share with you all a tutorial about how to query data via the DbSet in Entity Framework. If it was useful for me, it could be useful for somebody else as well. :)

​

Queries are specified using Language Integrated Query (LINQ), a component in the .NET Framework that provides query capability against collections in C# or VB. LINQ queries can be written. Query syntax shares a resemblance with SQL. The EF Core provider that you use is responsible for translating the LINQ query into the actual SQL to be executed against the database.

​

https://www.learnentityframeworkcore.com/dbset/querying-data