Simplify LINQ statement getting random record
Hello I have this LINQ statement. I want to know if anyone sees a way to simplify it so I do not have to get a list then take from that list a random record
Random rand = new Random();
var AdList =
(from a in Advertisements
join c in Companies on a.AdvertiementOwnerID equals c.CompanyID
where a.AdvertisementType=="Bann
select new {
a.AdvertisementID,
a.AdvertisementType,
a.AdvertiementActive,
a.AdvertisementText,
a.AdvertisementImageLocati
a.AdvertisementAlt,
c.CompanyName,
c.Website }
).ToList(); <-- would like to do all here
int toSkip = rand.Next(0, AdList.Count); problem here do not know how to get count in above list and use it as random Max val
var AdList2 = AdList.Skip(toSkip).Take(1
AdList2.Dump(); // LINQPad dumps
Random rand = new Random();
var AdList =
(from a in Advertisements
join c in Companies on a.AdvertiementOwnerID equals c.CompanyID
where a.AdvertisementType=="Bann
select new {
a.AdvertisementID,
a.AdvertisementType,
a.AdvertiementActive,
a.AdvertisementText,
a.AdvertisementImageLocati
a.AdvertisementAlt,
c.CompanyName,
c.Website }
).ToList(); <-- would like to do all here
int toSkip = rand.Next(0, AdList.Count); problem here do not know how to get count in above list and use it as random Max val
var AdList2 = AdList.Skip(toSkip).Take(1
AdList2.Dump(); // LINQPad dumps
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi charlesbaldo;
Here is a Linq to Entity Framework query which will return random records from the table. It can be configured to return one, two or more or all in random order. And the ordering is done on the server.
Here is a Linq to Entity Framework query which will return random records from the table. It can be configured to return one, two or more or all in random order. And the ordering is done on the server.
var AdList =
(from a in Advertisements
join c in Companies on a.AdvertiementOwnerID equals c.CompanyID
where a.AdvertisementType=="Banner"
orderby Guid.NewGuid()
select new {
a.AdvertisementID,
a.AdvertisementType,
a.AdvertiementActive,
a.AdvertisementText,
a.AdvertisementImageLocation,
a.AdvertisementAlt,
c.CompanyName,
c.Website
}).ToList(); // This will return all records in random order
// }).FirstOrDefault(); // This will return one records randomly each time
// }).Take(X); // This will return X random record
Premium Content
You need an Expert Office subscription to comment.Start Free Trial