We sometime need to show random items from our databases on users screen. Random photos of the week, random sayings and so many situations the pages look so good when there is a bunch of sticks with variety. This is nice but real good headache to solve when we have a huge list of items in the database, because randomizing at the program level using a huge list not a good idea having overhead to the memory. Simple sql will solve the issue like this SELECT TOP 10 * FROM tbl_items ORDER BY NewID() Filters out tem items randomly from table tbl_items. If you use Linq to sql as your query provider You have to use a partial class for your data context class and introduce a method to get a new Guid as follows Let DBContext be your datacontext class, Then create a new class public partial class DBContext { public Guid NewID() { return Guid.NewGuid(); ...