c# - MVC LINQ Sort / OrderBy a Model -

the each loop works setting pickupdistancesort column correctly, can't model sort can display rows in ascending order based on newly set pickupdistancesort values. pickupdistancesort data type of long. model displays in view, it's not sorted. how sort model before it's sent view?

    public actionresult jobsdistancesorted()     {                     var model = j in db.jobs select j;          foreach (var item in model)         {             item.pickupdistancesort = icn.custommethods.                    getdistance(34.180046081543, -118.309028625488,                    item.pickuplatitude, item.pickuplongitude);         }          model = model.orderby(s => s.pickupdistancesort);         return view("jobheadings", model);     } 

you have convert list stores items locally, , can call orderby on local list. calling orderby on iqueryable result in new database query, in values not stored.

public actionresult jobsdistancesorted() {                 var model = db.jobs.tolist();      foreach (var item in model)     {         item.pickupdistancesort = icn.custommethods.                getdistance(34.180046081543, -118.309028625488,                item.pickuplatitude, item.pickuplongitude);     }     return view("jobheadings", model.orderby(s => s.pickupdistancesort)); }