Linq

[shapper]

Hello,

I have the following LINQ query:

PagedList<ProfessorPaper> papers = (from p in
database.Professors
orderby p.Name
select new ProfessorPaper {
Professor = p,
Tags = new List<Tag> {
from pt in
database.ProfessorTags
join t in database.Tags
on pt.TagID equals t.TagID
where pt.ProfessorID ==
p.ProfessorID
select t
}
}).ToPagedList(page ?? 1,
10);

I am getting the error:
"The best overloaded Add method
'System.Collections.Generic.List<MyApp.Models.Tag>.Add(MyApp.Models.Tag)'
for the collection initializer has some invalid arguments."

In "from pt in database.ProfessorTags"

And the error:
Argument '1': cannot convert from
'System.Linq.IQueryable<MyApp.Models.Tag>' to 'MyApp.Models.Tag'

In "select t"

What am I doing wrong?

Thanks,
Miguel

 

[Jon Skeet [C# MVP]]

I am getting the error:
  "The best overloaded Add method
'System.Collections.Generic.List<MyApp.Models.Tag>.Add(MyApp.Models.Tag)'
for the collection initializer has some invalid arguments."

In "from pt in database.ProfessorTags"

And the error:
Argument '1': cannot convert from
'System.Linq.IQueryable<MyApp.Models.Tag>' to 'MyApp.Models.Tag'

In "select t"

What am I doing wrong?

Change the curly braces around that expression to parentheses - you
should be passing in the query expression as a constructor parameter.

Or get rid of the constructor completely and just call ToList() on the
query expression.

Jon