Entity Framework Core LINQ Queries

 Asp.Net Core uses Entity Framework Core to perform database operations like SELECT, INSERT, UPDATE and DELETE. Also SELECT involves various types like selecting specific columns, selecting specific rows, ordering rows, grouping rows, etc. In the following posts we shall see on how to perform various types of LINQ queries to achieve these requirements.

To perform LINQ queries we need an underlying SQL table and some data, for these sample we shall use the following tables and data. In the following posts we will use these table to perform different types of operations list SELECT, JOIN, WHERE, INSERT, UPDATE etc


Table Structure

Table data