public IEnumerable<dynamic> GetHotPosts()
        {
            //The dataset isn't recent, so we get to fake some dates!
            DateTime WhenItAllBegins = new DateTime(2011, 3, 25, 0, 0, 0);
            dynamic table = new Post();

            var hotposts = table.Query(@"With hotposts as (
            select p.postid, p.answercount,p.viewcount,p.title,p.tags, p.owneruserid
            from posts p
            where p.posttypeid = 1 and p.creationdate >= '03-31-2011'
            order by p.viewcount desc
            limit 20)
            Select post.postid, post.answercount,post.viewcount,post.title,post.tags,u.userid,u.displayname,u.reputation
            FROM hotposts as post
            inner join users u on post.owneruserid = u.userid");

            return hotposts ;
        }
 public IEnumerable<dynamic> GetRecentPosts()
 {
     dynamic table = new Post();
     var recentposts = table.Query(@"select p.postid, p.answercount,p.viewcount,p.title,p.tags,u.userid,u.displayname,u.reputation
                     from posts p inner join users u on p.owneruserid = u.userid
                     where p.posttypeid = 1
                     order by p.creationdate desc
                     limit 20");
     return recentposts;
 }