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

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -