Random Linq Query

Question

how I can get a random row from a selection in my linq query?

I tried:

Bot bot = (from a in dc.Bot
           select a).OrderBy(x => Guid.NewGuid()).First();

But doesn't work, I ever get the same.

Answer 1

I would use Skip

var query = from a in dc.Bot
            select a;

int random = new Random().Next(query.Count);

Bot bot = query.Skip(random).First();