In the end what I actually did was this.
var online = context.VehicleUsages.Where(m => m.AccountId == userId)
.GroupBy(p => p.VehicleId)
.Select(p => p.FirstOrDefault(w => w.Id == p.Max(m => m.Id)))
.OrderBy(p => p.VehicleOnOff)
.Include(p => p.Vehicle)
.Include(p => p.Driver)
.Include(p => p.Vehicle.VehicleTypes)
.ToList();
var viewModel = new DashboardViewModel
{
OnlineVehicles = online
};
return View(viewModel);
And I just checked it in Razor View
@foreach (var veh in Model.OnlineVehicles)
{
if (veh.VehicleOnOff == true)
{
<!--html code here-->
}
}