select random data from database in mvc4 C#

Question

I have database. Actually,i am doing for it display 10 image newest from my database but i want to display random 10 image from database.How can i do it?

public ActionResult Details(int id)
    {
        var products = db.TblProductImages.Include(t => t.TblProduct);
        ViewData["viewcategory"] = (from p in products orderby  p.ProductID   descending select p).Take(10).ToList();
        if (image == null)
        {
            return HttpNotFound();
        }
        return View(image);
    }

Why can't you just generate 10 random numbers in the range of the available index (0 -> db Length)? stackoverflow.com/questions/2706500/… — bill
– bill, Commented Jun 11, 2015 at 16:15

Alioza · Accepted Answer · 2015-06-11 16:15:07Z

4

Do this:

(from p in products orderby  Guid.NewGuid() select p).Take(10).ToList()

answered Jun 11, 2015 at 16:15

Alioza

1,7801 gold badge12 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ManOVision Over a year ago

I love orderby Guid.NewGuid() for random. I use it a lot.

Collectives™ on Stack Overflow

select random data from database in mvc4 C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related