问Min value实体框架与ASP.NET MVC的比较

EN

namespace Test
{
    class Warehouse
    {
        public int Id { get; set; }
        public int DeliveryTime { get; set; }

        public Warehouse(int id, int deliveryTime)
        {
            Id = id;
            DeliveryTime = deliveryTime;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;

namespace Test
{
    class Service
    {
        public IQueryable<Warehouse> Warehouses { get; set; }
        public Service(int quantity)
        {
            var list = new List<Warehouse>();
            var random = new Random();
            for (var i = 0; i < quantity; i++)
            {
                list.Add((new Warehouse(i, random.Next(1, 100))));
            }
            Warehouses = list.AsQueryable();
        }

        public Warehouse GetQuickestWarehouse(int a, int b)
        {
            return Warehouses.Where(w => w.Id == a || w.Id == b).OrderBy(w => w.DeliveryTime).FirstOrDefault();
        }
    }
}

using System;
using System.Linq;

namespace Test
{
    class Program
    {
        static void Main(string[] args)
        {
            var service = new Service(100);
            var a = service.Warehouses.FirstOrDefault(w => w.Id == 1);
            var b = service.Warehouses.FirstOrDefault(w => w.Id == 2);
            var min = service.GetQuickestWarehouse(a.Id, b.Id);

            Console.WriteLine($"Deliverytime for a: {a.DeliveryTime}");
            Console.WriteLine($"Deliverytime for b: {b.DeliveryTime}");
            Console.WriteLine($"Quickest Warehouse has Id: {min.Id} with delivery time: {min.DeliveryTime}");
            Console.ReadKey();
        }
    }
}

var Ids = new List<int>() { 1, 2 };

var lowest = db.Warehouse.Where(w=> Ids.Contains(w.Id)).OrderBy(a => a.DeliveryTime).FirstOrDefault();

var date = db.Warehouse.Min(a => a.DeliveryTime);
var lowest = db.Warehouse.FirstOrDefault(a =>  Ids.Contains(a.Id) && DateTime.Equals(a.DeliveryTime,date));