Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Random element of List<T> from LINQ SQL

Tags:

c#

.net

random

linq

I'm using C# 3.5 and am currently using Linq to get all users from a user table and put them in a list.

Now I would like to return a random user from that list. What's the best way to go about doing that?

Edit: Found it here: How to get a Random Object using Linq

like image 274
PassionateDeveloper Avatar asked Jan 06 '11 13:01

PassionateDeveloper


4 Answers

Like this:

var rand = new Random();
var user = users[rand.Next(users.Count)];
like image 185
SLaks Avatar answered Nov 18 '22 01:11

SLaks


Use ElementAt:

var rand = new Random();
var user = users.ElementAt( rand.Next( users.Count() ) );
like image 35
Danko Durbić Avatar answered Nov 18 '22 03:11

Danko Durbić


Why not create a generic helper and/or extension?!

namespace My.Core.Extensions
{
    public static class EnumerableHelper<E>
    {
        private static Random r;

        static EnumerableHelper()
        {
            r = new Random();
        }

        public static T Random<T>(IEnumerable<T> input)
        {
            return input.ElementAt(r.Next(input.Count()));
        }

    }

    public static class EnumerableExtensions
    {
        public static T Random<T>(this IEnumerable<T> input)
        {
            return EnumerableHelper<T>.Random(input);
        }
    }
}

Usage would be:

        var list = new List<int>() { 1, 2, 3, 4, 5 };

        var output = list.Random();
like image 15
longda Avatar answered Nov 18 '22 03:11

longda


for Entity Framework or Linq 2 Sql, can use this extension method

public static T RandomElement<T>(this IQueryable<T> q, Expression<Func<T,bool>> e)
{
   var r = new Random();
   q  = q.Where(e);
   return q.Skip(r.Next(q.Count())).FirstOrDefault();
}
// persons.RandomElement(p=>p.Age > 18) return a random person who +18 years old
// persons.RandomElement(p=>true) return random person, you can write an overloaded version with no expression parameter
like image 10
Cihan Yakar Avatar answered Nov 18 '22 03:11

Cihan Yakar