在数据结果集中随机获取一条数据
linq to sql中还可以在dbcontext下定义
[Function(Name = "NEWID", IsComposable = true)]
public Guid NEWID() {
return ((Guid)(this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod()))).ReturnValue));
}
QuestionModel=(from d in _dbContext.Questions.Where(o =>
QuestionTypeIDS.Contains(o.TypeID))
orderby new dbcontext().NEWID()
select d).FirstOrDefault();
framework4.0以后版本均可以这样随机取数据
QuestionModel=(from d in _dbContext.Questions.Where(o =>
QuestionTypeIDS.Contains(o.TypeID))
orderby Guid.NewGuid()
select d).FirstOrDefault();
QuestionModel = _dbContext.Questions.Where(o =>
QuestionTypeIDS.Contains(o.TypeID)).ToList()
.OrderBy(i => Guid.NewGuid())
.FirstOrDefault();