linq 排名
数据访问用了 entity，数据库中有个player表 ，每个player 有个score，我想获得某个player的score的排名，该怎么写啊

using (var data = new Entities1()) {

Player player = data.Player.FirstOrDefault(d => d.Email_address == email);

}



[解决办法]
oderby，排序。
[解决办法]
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;
}
}

}
[解决办法]
var tr = from p in player
orderby score
select p;