Linq. Select.

[shapper]

Hello,

I have two tables:
Polls PollID, Question
Options OptionID, Answer

Given a OptionID I want to get the poll to which the Option "Belongs":
Poll poll = database.Polls. Select(p =p.Options.Sele ct(o =>
o.OptionID = id)).SingleOrDe fault;

I am not sure if this is the right way but I am getting an error
anyway:
Cannot convert method group 'SingleOrDefaul t' to non-delegate type
'MyApp.Models.P oll'. Did you intend to invoke the method?

I have all relations between tables well defined and I used LinqToSQL
classes.

How should I do this?

Thanks,
Miguel

[Martin Honnen]

shapper wrote:

I have two tables:
Polls PollID, Question
Options OptionID, Answer

Given a OptionID I want to get the poll to which the Option "Belongs":
Poll poll = database.Polls. Select(p =p.Options.Sele ct(o =>
o.OptionID = id)).SingleOrDe fault;

I am not sure if this is the right way but I am getting an error
anyway:
Cannot convert method group 'SingleOrDefaul t' to non-delegate type
'MyApp.Models.P oll'. Did you intend to invoke the method?

I have all relations between tables well defined and I used LinqToSQL
classes.

How should I do this?

First of all, SingleOrDefault is a method and methods are called this way:

Poll poll = database.Polls. Select(p =p.Options.Sele ct(o =>
o.OptionID = id)).SingleOrDe fault();

However I don't think you want a Select, you want a Where e.g.

Poll poll = database.Polls. Where(p =p.Options.Any( o =>
o.OptionID = id)).SingleOrDe fault();
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/