LINQ Returning Duplicate Results and return a row number.
Posted on 2010-11-17
I am receiving duplicate records with this query... any ideas?
Second question here, I need to know the row number for each record, via a count. Thanks.
var members = from f in dc.MemberFollowerCounts
join m in dc.Members
on f.MemberId equals m.MemberId into joinedMemberCount
from m in joinedMemberCount.DefaultIfEmpty()
orderby f.FollowerCount descending
name = m.Name,
biography = m.Biography,
followers = f.FollowerCount,
profileImageURL = m.ProfileImageURL,
TwitterUserName = m.TwitterUserName.Replace("@",""),
status = m.Status