怎么获得最新一条语句？

[zhangshuang555]

我的语句是这样的
 var userbet = (from d in tt.UserBet where d.UserName == 'aaaa'
orderby d.QiShu descending 
 select d.QiShu).Distinct().FirstOrDefault();


我从数据库中查询出来的是

。。。
2202
2201
2200
2199
假如就这几条数据

为何我每次 userbet都等于2199

我想获得最新的一条，，求解，，

[zhangshuang555]

终于根据1楼的写法，写了出来！

var userbet = (from d in tt.UserBet where d.UserName == 'aaaa'
select d.QiShu).Distinct().OrderByDescending(s => s.GetValueOrDefault()).FirstOrDefault();

[暖枫无敌]

var userbet = (from d in tt.UserBet where d.UserName == 'aaaa'
select d.QiShu).Distinct().OrderByDescending(s => s.QiShu).FirstOrDefault();

[q107770540]

orderby d.QiShu descending
==========
orderby Convert.ToInt32(d.QiShu) descending