public IHttpActionResult GetCustomersPerSuburb(FilterRequest filter) { var model = _repoSite.AsQueryable() .Select(s => new { Customer = new List <int>() { s.Site.CustomerId }, Suburb = new List <char>() { s.Site.Address.Suburb.Name }, //need to Fetch customer count for CustomerSite where its equal to a == zone }).ToList(); return(Ok(model)); }
public IQueryable <Site> AsQueryable() { return(_repoSite.AsQueryable()); }