asp.net mvc - Select random row without duplication using entity framework4.5 mvc4 -
i have tried following code need random row out duplication based on name field.
list list = db.logos.where(a => a.logoname != "empty.png").orderby(r => guid.newguid()) .groupby(a => a.logoname) .select(g => g.firstordefault()).take(8).tolist();
but did not randomly have tried code shuffling correctly duplicate code not apply, code below
list list = (from c in db.logos c.logoname != "empty.png" select c).orderby(r => guid.newguid()).take(3).tolist();
please how select both duplication , random rows.
can please try below one?
var result = (from logo in db.logos (logo.logoname != "empty.png") orderby logo.logoname select logo).distinct();
Comments
Post a Comment