我有一个简单的Linq查询,我想扩展它,以便我可以首先对VoteCount字段中的所有值求和,然后为每个被提名者分配获得的投票百分比。
以下是代码:
以下是代码:
TheVoteDataContext db = new TheVoteDataContext();
var results = from n in db.Nominees
join v in db.Votes on n.VoteID equals v.VoteID
select new
{
Name = n.Name,
VoteCount = v.VoteCount,
NomineeID = n.NomineeID,
VoteID = v.VoteID
};