Entity Framework -Database first approach

SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and MS SQL Server and other databases.LINQ queries return results as objects.

 

For more please refer this site

https://www.c-sharpcorner.com/article/linq-for-beginners/

https://docs.microsoft.com/en-us/dotnet/csharp/tutorials/working-with-linq

You can follow below URL, with step by step implementing entityframework, incase if you want to have DB first then skip step 4 and implement step 6 which is getting class model from database, this new feature is availble in EF Core 3 +

 

https://github.com/Amitpnk/militaryapp-entityframeworkcore#step-6---reverse-engineering-from-existing-database 

 

Below is simple setting up of EF  

Hi Ramu,

 

Include is used to do eager loading in entity framework. When you want to get your refence table related data in single call.

https://entityframeworkcore.com/knowledge-base/53234499/using-include-with-intersect-union-exclude-in-linq