Max in LINQ Query in Entity Framework Core

Max method is used to find max 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 max = (from product in databaseContext.Products
                           select product).Max(product => product.Price);
                Console.WriteLine("Min: " + max);
            }
        }
    }
}

Output

Max: 43

You can use combination of Max 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 max = (from product in databaseContext.Products
                           where product.Status == true 
                           select product).Max(product => product.Price);
                Console.WriteLine("Min: " + max);
            }
        }
    }
}

Output

Max: 19

You can use combination of Max 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 max = (from product in databaseContext.Products
                           where product.Status == true 
                           select product.Price).Max();
                Console.WriteLine("Min: " + max);
            }
        }
    }
}

Output

Max: 19