CODEWITHSUNDEEP
c#asp.net-mvc-4
doduc812
doduc812

Reputation: 3

select random data from database in mvc4 C#

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);
    }

Upvotes: 0

Views: 1510

Answers (1)

Alioza
Alioza

Reputation: 1770

Do this:

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

Upvotes: 4

Related Questions