List of Posts written during Oct 2021

This is a list of of posts written during the month Oct 2021

Categories | About |     |  

List of Posts

This is the complete list of categories of posts written during Oct 2021. They have been ordered by the publish date, with the most recent first.

  1. Published: 01-Oct-2021
    This is an explanation of SingleOrDefault, FirstOrDefault and Find methods from a practical point of view. We have explained when to use which one and how to use. We have also explained how Single is different from First, and how Single is different from SingleOrDefault, and also how First is different from FirstOrDefault.


  2. Published: 01-Oct-2021
    This is an explanation of Where, Include and the ToList methods from a practical point of view. We have explained when to use which one and how to use. We have also explained how a SQL JOIN can be performed by using the "Include" function of EF Core.


  3. Published: 01-Oct-2021
    EF Core translates your LINQ expressions into SQL language queries. However, sometimes it is easier, convenient and faster (as determined by testing) to run queries directly on a database. This tutorial explains how to run SELECT, UPDATE, INSERT, DELETE and execute Stored Procedures and obtain the resultset directly.


  4. Published: 01-Oct-2021
    A result set can be sorted in ascending as well as descending order. It is even possible to perform a chained sorting by using "ThenBy" and "ThenByDescending" methods. Finally we discuss whether "OrderBy" should be before or after "Where".