public ActionResult MelhorCliente() { using (var context = new MVC_EntityContext()) { string sql = @"Select nome,sum(cost_paid) as valor FROM stays INNER JOIN clients ON stays.clientid=clients.clientid GROUP BY stays.clientid,nome ORDER BY sum(cost_paid) DESC"; var melhor = context.Database.SqlQuery <Campos>(sql); ViewBag.melhor = melhor.ToList()[0]; } return(View()); }