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