How to get a random nr. of items out of a repository with LINQ?

Asked Jul 15 '14 at 16:48

Active Jul 15 '14 at 17:11

Viewed 78 times

So I have a repository of objects that I'm looking at and I want to select the default 3 random items from it. I want to do this without retrieving all the items and then select the 3, I want the logic that randomizes to happen before anything else and want to do that all in one LINQ query. I'm thinking this is possible.

I'd use the query in a single method with a default parameter that signifies the number of items wanted through that query.

asked Jul 15 '14 at 16:48

user3046061

1

@Neolisk That's ordering the items of an in memory collection, not of a database. – Servy Jul 15 '14 at 17:00
Yes, I have to query against a database. – user3046061 Jul 15 '14 at 17:05
What library are you using? linq2sql or Entity Framework? – vmg Jul 15 '14 at 17:23
1

possible duplicate of [Random row from Linq to Sql](http://stackoverflow.com/questions/648196/random-row-from-linq-to-sql) – vmg Jul 15 '14 at 17:25
Entity Framework, I already solved it, but post if you have a best practice reply. – user3046061 Jul 15 '14 at 22:25

How to get a random nr. of items out of a repository with LINQ?

0 Answers0