Monday, June 4, 2012

Random data with LINQ

Random data with LINQ

in Memory

var rnd = new Random();
var data = datas[rnd.Next(datas.Count)];  //execute immediately

on Database

var rnd = new Random();
var count = data.Count();  //execute
var data = datas.ElementAt(rnd.Next(count)) //no execution
var result = data.ToList(); //execute query

Or

//no execution
var data = datas.OrderBy(p=> Guid.NewGuid()).Skip(rnd.Next(count)) 

No comments:

Post a Comment