hello,
i have this linQ query, how to get 6 random records on each page load
in sql we use to do order by new guid()
var q = (from p in db.Profiles
where p.ProfileStatus == "Completed" && p.UserName != this.Page.User.Identity.Name
select p).Distinct().Take(6).ToList();