linq: order by random

by

http://msdn.microsoft.com/en-us/library/system.guid.newguid.aspx

return (from examQ in idb.Exam_Question_Int_Tbl
      where examQ.Exam_Tbl_ID==exam_id
      select examQ).OrderBy(x => Guid.NewGuid()).Take(50);

If this is LINQ-to-SQL you could simply add a ORDER BY NEWID() to your SELECT statement.

As commented it might be better to use an algorithm like Fisher-Yates Shuffle, here is an implementation: https://stackoverflow.com/a/375446/284240

More Related Contents:

  1. How to display words that appear more than 'x' times in a text? [closed]
  2. Getting same numbers from random number generator even though it’s out of the loop. Why? [closed]
  3. Retrieving Property name from lambda expression
  4. How to access random item in list?
  5. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  6. When to use BlockingCollection and when ConcurrentBag instead of List?
  7. How can I get every nth item from a List?
  8. How to get the index of an element in an IEnumerable?
  9. How do I invoke an extension method using reflection?
  10. How do I generate a random integer in C#?
  11. Use LINQ to group a sequence of numbers with no gaps
  12. Find index of a value in an array
  13. LINQ: combining join and group by
  14. Add two Lists of different length in C#
  15. Generate N random and unique numbers within a range
  16. Number of occurrences of a character in a string [duplicate]
  17. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  18. Linq query built in foreach loop always takes parameter value from last iteration
  19. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  20. Rotate – Transposing a List using LINQ C#
  21. Find() vs. Where().FirstOrDefault()
  22. How to Get XML Node from XDocument
  23. Use linq to generate direct update without select
  24. LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
  25. Get List element position in c# using LINQ
  26. Linq style “For Each” [duplicate]
  27. Does the order of LINQ functions matter?
  28. Pros and cons of RNGCryptoServiceProvider
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment