Min method is used to find min value of any numeric column in database.
using EntityFrameworkCore_ConsoleApp.Models;
namespace EntityFrameworkCore_ConsoleApp
{
public class Program
{
static void Main(string[] args)
{
using (var databaseContext = new DatabaseContext())
{
var min = (from product in databaseContext.Products
select product).Min(product => product.Price);
Console.WriteLine("Min: " + min);
}
}
}
}
Output
Min: 4
You can use combination of Min 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 min = (from product in databaseContext.Products
where product.Status == true
select product).Min(product => product.Price);
Console.WriteLine("Min: " + min);
}
}
}
}
Output
Min: 10
You can use combination of Min method and Where and Select as below:
using EntityFrameworkCore_ConsoleApp.Models;
namespace EntityFrameworkCore_ConsoleApp
{
public class Program
{
static void Main(string[] args)
{
using (var databaseContext = new DatabaseContext())
{
var min = (from product in databaseContext.Products
where product.Status == true
select product.Price).Min();
Console.WriteLine("Min: " + min);
}
}
}
}
Output
Min: 10