Count in LINQ Query in Entity Framework Core

Count method is used to return the number of elements present in the collection or the number of elements that have satisfied a given condition.

using EntityFrameworkCore_ConsoleApp.Models;

namespace EntityFrameworkCore_ConsoleApp
{
    public class Program
    {
        static void Main(string[] args)
        {
            using (var databaseContext = new DatabaseContext())
            {
                var count = (from product in databaseContext.Products
                             select product).Count();
                Console.WriteLine("Count: " + count);
            }
        }
    }
}

Output

Count: 8

You can add condition to Count method as below:

using EntityFrameworkCore_ConsoleApp.Models;

namespace EntityFrameworkCore_ConsoleApp
{
    public class Program
    {
        static void Main(string[] args)
        {
            using (var databaseContext = new DatabaseContext())
            {
                var count = (from product in databaseContext.Products
                             select product).Count(product => product.Status == true);
                Console.WriteLine("Count: " + count);
            }
        }
    }
}

Output

Count: 4

You can use combination of Count method and Where as below:

using EntityFrameworkCore_ConsoleApp.Models;

namespace EntityFrameworkCore_ConsoleApp
{
    public class Program
    {
        static void Main(string[] args)
        {
            using (var databaseContext = new DatabaseContext())
            {
                var count = (from product in databaseContext.Products
                             where product.Status == true
                             select product).Count();
                Console.WriteLine("Count: " + count);
            }
        }
    }
}

Output

Count: 4