How to select random records using LINQ from database

Question

Hi In my MVC application  I have to fetch random records from database using LINQ and it should be assigned to different employees. i.e. if we have 50 records in table and 5 Employees are there records should be fetched randomly and these fifty should be distributed(assigned )to these 5 employees as 10 for each one. If possible please help...... Thanks in advance.

Vulpes · Answer

Sure no problem :)

Jaima Joseph · Answer

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.........

Vulpes · Answer

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 { employee[i] = query.Skip(i * 10).Take(10).ToArray(); }