How to select random records using LINQ from database

Sure, no problem :)

0

Thank you.........Thank you so much.........This is what I wanted. I have to finish some other work to implement this, I'l let you know the result after implementing this .........If I check 'This is the correct answer',will this question be closed??In case if I face some problem while implementing I would like to communicate with you....So I am not closing it.........

Once again Thankss.........

0

Vulpes12y ago

Check this thread for how you can get records in a random order using LINQ to SQL:

http://stackoverflow.com/questions/648196/random-row-from-linq-to-sql

You can then allocate them amongst your 5 employees as follows:

query.Take(10)

query.Skip(10).Take(10)

query.Skip(20).Tale(10)

query.Skip(30).Take(10)

query.Skip(40).Take(10)

or using a loop:

for(int i = 0; i < 5; i++)

{

employee[i] = query.Skip(i * 10).Take(10).ToArray();

}

0