Using a multiple select in a Linq-to-SQL expression

Question

I need to call a model + object in my table in view .. how can I add the variable TotalTime and insert it in my table?

This is my code :

schoolinfo az = new schoolinfo();

var durer = 3;
var EstimationPrep = 20;

var  TotalTime = durer * az.Location.Distance(point) + EstimationPrep;

var places = (from u in context.schoolinfo 
              orderby u.Location.Distance(point)
              where u.Location.Distance(point) < DistanceMax
              select u).Take(10);
var nearschools = places.ToList();

return View(nearschools);

Thanks

Insert where? as a new column? in all the rows the same value? [edit] your question and please make it clearer — Pikoh, Oct 23 '17 at 16:04

score 0 · Answer 1 · answered Oct 23 '17 at 16:09

It's not exactly clear but if you just want to add TotalTime to every row in places you can do that like this:

var places = (from u in context.schoolinfo 
          orderby u.Location.Distance(point)
          where u.Location.Distance(point) < DistanceMax
          select new { u.column1, TotalTime }).Take(10);

Using a multiple select in a Linq-to-SQL expression

1 Answers1