Re: Linq. OrderBy and Where.

[Marc Gravell]

Ah right - I just saw your explanation of "Source"; yes - I'd have 2
queries, then:

switch(Source) {
case "File":
viewData.blah = (from t in database.Tags
where t.FileCount != 0
orderby t.FileCount
select new {...}).ToList();
break;
case "Post":
viewData.blah = second query;
break;
}

Marc

[shapper]

On Sep 3, 9:40*pm, Marc Gravell <[e-mail]:

Ah right - I just saw your explanation of "Source"; yes - I'd have 2
queries, then:

switch(Source) {
* case "File":
* * viewData.blah = (from t in database.Tags
* * * * * * * where t.FileCount != 0
* * * * * * * orderby t.FileCount
* * * * * * * select new {...}).ToList();
* * break;
* case "Post":
* * viewData.blah = second query;
* * break;

}

Marc

Thanks!

[shapper]

On Sep 3, 9:40*pm, Marc Gravell <[e-mail]:

Ah right - I just saw your explanation of "Source"; yes - I'd have 2
queries, then:

switch(Source) {
* case "File":
* * viewData.blah = (from t in database.Tags
* * * * * * * where t.FileCount != 0
* * * * * * * orderby t.FileCount
* * * * * * * select new {...}).ToList();
* * break;
* case "Post":
* * viewData.blah = second query;
* * break;

}

Marc

Not done yet ...

viewData.TagsPapers = (from t in database.Tags
where t.FileCount != 0
orderby t.FileCount
select new TagPaper {
Tag = t,
FileCount = t.FilesTags.Count,
PostCount = t.PostsTags.Count
}).ToList();

I get an error on where and orderby ...

FileCount is not a property of Tag! It is a property of TagPaper ...
this is why I don't know how to do this.

Any idea?

Thanks,
Miguel

[Marc Gravell]

either: where t.FilesTags.Count != 0
or:
select new TagPaper {
Tag = t,
FileCount = t.FilesTags.Count,
PostCount = t.PostsTags.Count
} into tmp
where tmp.FileCount != 0
select tmp).ToList();

[shapper]

On Sep 3, 10:15*pm, Marc Gravell <[e-mail]:

either: where t.FilesTags.Count != 0
or:
select new TagPaper {
* Tag = t,
* FileCount = t.FilesTags.Count,
* PostCount = t.PostsTags.Count} into tmp

where tmp.FileCount != 0
select tmp).ToList();

I have the following:

viewData.TagsPapers = (from t in database.Tags
orderby t.Name
select new TagPaper {
Tag = t,
PostCount = t.PostsTags.Count
} into tp
where tp.PostCount != 0
orderby tp.PostCount
select tp).Take(50).ToList();

I need the items to be ordered by name but before that I want to get
the 50 items with the highest PostCount.
So I ordered it by PostCount and used Take(50).

However, I think Take is getting the first 50 items of the final list
and not from the tp which is ordered by PostCount.

Does this makes any sense? How can I fix this?

Note: I am using take because I think there is no TOP in Linq.

Thanks,
Miguel