How can I get a randomized collection out of linq-to-sql model?
What's the right syntax for this?
var words= from h in db.Words
orderby(a => Guid.NewGuid()).ToList()) //erro开发者_如何转开发r
select h;
var words= from h in db.Words
orderby((a => Guid.NewGuid()).ToList()) //error
select h;
var words= from h in db.Words
orderby(Guid.NewGuid()) //no error but doesn't sort
select h;
Assuming that you don't mind not having all of your code embedded in the LINQ query, you can try this:
Random rnd = new Random();
var randomWords = from h in db.Words
orderby rnd.Next()
select h;
Though if you need the Guid approach:
var words = from h in db.Words
orderby Guid.NewGuid()
select h;
精彩评论