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());
}
