Linq Query

[Shapper]

Hello,

I have three tables: Polls (PollId, Question), Options (OptionID, Answer) and Votes (VoteID, OptionID)

I then created two Wrapper Classes:

PostPaper with the following properties:
public Poll Poll { get; set; }
public List<OptionPaper> Options { get; set; }
public string OptionsCSV { get; set; }

OptionPaper with the following properties:
public Option Option { get; set; }
public int Votes { get; set; }

I need, given an PollId, to get fill a PostPaper with all its options and for each option count the votes:

pollViewData.PollPaper = (from p in database.Polls
join o in database.Options on p.PollID equals o.PollID
join v in database.Votes on o.OptionID equals v.OptionID
where p.PollID == id
group o by p into pog
select new PollPaper {
Poll = pog.Key,
Options = new List<OptionPaper> {
Option = ??????
Votes = ?????
}.ToList(),
OptionsCSV = string.Join(", ", pog.Select(o => o.Answer).ToArray())
}).SingleOrDefault();

I am having problems in creating the Option and Count the votes of each OptionPaper in List Options.

Could someone, please, help me out?

Thanks,
Miguel

[nabeelisnabeel]

First of all use [CODE] tags to post your code.

[boudino]

I think it should be: Options = { { Option = ??????, Votes = ????? }}