How to get Random entries from database in mvc4 using Linq

Question

I want my search to return Random entries from database.How to do this?
This is my search function where i am using Join query and have taken a new model to pass Attributes.

var planetfeedsOrder = from a in db.PlanetFeeds
                       where a.PlanetFeedOwnerId == id || a.PlanetFeedPosterId == id
                       && a.CurrentState != 1
                       join c in db.Graphs on a.PlanetFeedItemGraphId equals c.GraphID
                       join u in db.UserInfos on a.PlanetFeedOwnerId equals u.UserInfoID
                       orderby a.PostDate descending
                       select new UserInfoViewModel
                       {
                        AvatarURL = u.AvatarURL,
                        UserName=u.FirstName +" "+u.LastName,
                        GraphItemDescription = c.GraphItemDescription,
                        GraphItemURL = c.GraphItemURL,   
                        isRootFeed = a.isRootFeed,
                        PostDate = a.PostDate,
                        CurrentState = a.CurrentState,
                        };                    
return PartialView("_PlanetfeedPartial",planetfeedsOrder.Take(itemCount).ToList());

possible duplicate of Random row from Linq to Sql

Magnus
– Magnus

2014-10-05 10:34:27 +00:00
Commented Oct 5, 2014 at 10:34 — Magnus
– Magnus, Commented Oct 5, 2014 at 10:34
possible duplicate of EF Code First: How to get random rows

Gert Arnold
– Gert Arnold

2014-10-05 11:30:41 +00:00
Commented Oct 5, 2014 at 11:30 — Gert Arnold
– Gert Arnold, Commented Oct 5, 2014 at 11:30

Vlado Pandžić · Accepted Answer · 2014-10-05 12:34:03Z

2

By inserting the guid (which is random) the order with orderby would be random.:

  planetfeedsOrder.OrderBy(c => Guid.NewGuid()).Take(itemCount).ToList()

answered Oct 5, 2014 at 12:34

Vlado Pandžić

5,0758 gold badges50 silver badges82 bronze badges

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

Collectives™ on Stack Overflow

How to get Random entries from database in mvc4 using Linq

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related