ASP NET MVC如何在属性上调用Count然后打印出排序列表？
|
说我上了一堂课：
public class Post
{
public int PostId { get; set; }
public string Topic { get; set; }
public int UserId { get; set; }
[StringLength(5000)]
public string Body { get; set; }
public DateTime DateCreated { get; set; }
public string Name { get; set; }
public int Votes { get; set; }
}
Red | 70
Blue | 60
Green | 40
Yellow| 35
public List<string> GetPopularTopics(int count)
{
var posts = from p in db.Posts
group p by p.Topic into myGroup
select new
{
Topic = myGroup.Key,
Count = myGroup.Count()
};
return posts.ToList();
}
public IEnumerable<IGrouping<string,int>> GetPosts()
{
var posts = from p in db.Posts
group p by p.Topic into topicCounts
select new
{
Topic = topicCounts.Key,
Count = topicCounts.Count()
};
return posts.ToList();
}
没有找到相关结果
已邀请:
3 个回复
赐黄
public class MyCounts { public string Topic { get; set; } public int Count { get; set; } } public List<MyCounts> GetPopularTopics(int count) { var posts = from p in db.Posts group p by p.Topic into myGroup select new MyCounts { Topic = myGroup.Key, Count = myGroup.Count() }; return posts.ToList(); }室邢
var posts = from p in context.Posts group p by p.Topic into topicCounts select new { Topic = topicCounts.Key, Count = topicCounts.Count() };foreach(var p in posts) { Response.Write(String.Format(\"{0} - {1}\", p.Topic, p.Count)); }剿畦缄饥小
var posts = from p in context.Posts group p by p.Topic into topicCounts select new { Topic = topicCounts.Key, Count = topicCounts.Count() };public IEnumerable<TopicAndCount> GetPosts() { var posts = from p in context.Posts group p by p.Topic into topicCounts select new TopicAndCount { Topic = topicCounts.Key, Count = topicCounts.Count() }; }