EFCore
EFCore: If we apply multiple OrderBy in the linq queries, it will take the last one and skip the rest of the things. If you want sort the result based on multiple condition then we should use OrderBy with ThenBy for the ascending order. OrderByDescending with ThenByDescending for the descending order. When we use FirstOrDefault it uses select top 1 When we use LastOrDefault, we should use Orderby otherwise it will throw exception at run time. No compile time error Solution code for it When we use first/firstordefault/last/lastordefault/single/singleordefault, we should use orderby or orderbydescending before the firstordefault method Tracking is always expensive, avoid it where it's not required 1.First option to make the particular query as no tracking. 2. second options to make all the query as no tracking, in case if you want to particular query as tracking use as tracking method "AsTracking()" When we are writing generic method that time we use context.Add method t...