Entity Framework -Database first approach

Question

I want to understand how linq method works like below: DataModel.matter dataObject = _context.matters.AsNoTracking() .Include(lm => lm.country) .Include(lm => lm.matterarchive) .SingleOrDefault(lm => lm.id== id); I want to understand from basic

Harsh Shah · Answer

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

Amit Naik · Answer

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 https://www.c-sharpcorner.com/article/setting-up-entity-framework-in-console-application/

Jignesh Kumar · Answer

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

Farhan Ahmed · Answer

https://channel9.msdn.com/Events/TechEd/Europe/2008/TLA402