linq 排名

Question

数据访问用了 entity，数据库中有个player表 ，每个player 有个score，我想获得某个player的score的排名，该怎么写啊
 
    using (var data = new Entities1()) {
               
       Player  player = data.Player.FirstOrDefault(d => d.Email_address == email);
            
} 

Answer 1

 using (var data = new Entities1()) {
    
  var players = data.Player.orderby(p=>p.id);
int i=0;
foreach(var item idn players)
{
i++;
if(item.Email_address == email)
{
break;
}
}
    
} 

Answer 2

                     var tr = from p in player
                     orderby score
                     select p;