Entity Random Select from DB C# MVC

Question

Try to find the solution but i cant.

So problem is next one. I have the EDM model of database. I have a class with functions to get data from DB. Like this:

public IQueryable<photos> FindUserPhotos(string userlogin)
        {
            return from m in db.photos
                   where m.userlogin == userlogin
                   select m;
        }

How to get the Random 10 lines from DB?

possible duplicate of [Random row from Linq to Sql](http://stackoverflow.com/questions/648196/random-row-from-linq-to-sql) — Justin Niessner, Apr 27 '11 at 16:32

İbrahim Özbölük · Answer 1 · 2013-04-10T11:25:49.370

4

I always use this method for get custom entity OrderBy(x => Guid.NewGuid())

public photos Find10RandomUserPhotos(string userlogin)
{
   return db.photos.Where(x => x.userlogin == userlogin).OrderBy(x => Guid.NewGuid()).Take(10).ToList();
}

edited Apr 10 '13 at 11:25

answered Mar 31 '13 at 13:59

İbrahim Özbölük

3,162
23
20

score 0 · Accepted Answer · edited May 23 '17 at 12:24

0

Following Random row from Linq to Sql

public photos FindRandomUserPhoto(string userlogin)
{
   var qry = FindUserPhotos(userlogin);
   int count = qry.Count();
   int index = new Random().Next(count);
   return qry.Skip(index).FirstOrDefault();
}

public Array<photos> Find10RandomUserPhotos(string userlogin)
{
   var result = New Array<photos>;
   for (i = 0; i < 10; i++) {
      result.add(FindRandomUserPhoto(userlogin));
   }
   return result
}

edited May 23 '17 at 12:24

Community

1
1

answered Apr 27 '11 at 16:28

ariel

15,620
12
61
73

1

If this is a dupe, don't post the link as an answer...post a comment instead. – Justin Niessner Apr 27 '11 at 16:32
dont know how to vote do close.. maybe dont have permission yet? – ariel Apr 27 '11 at 16:36
its not the dublicate, im a new in mvc and i realy dont understand how to make in by that example – Evgeniy Labunskiy Apr 27 '11 at 16:42
updated.. maybe you can speed that up by using 10 skips with random based on count/10. – ariel Apr 27 '11 at 17:17

Entity Random Select from DB C# MVC

2 Answers2