public Post GetPost(int id)
{
using (var db = new Sova())
{
return(db.Post.FirstOrDefault(p => p.id == id));
}
}
public Comments GetComments(int id)
{
using (var db = new Sova())
{
return(db.Comments.FirstOrDefault(c => c.id == id));
}
}
//Post
public IList <Post> GetPost(int page, int pagesize)
{
using (var db = new Sova())
{
return(db.Post
.OrderBy(p => p.id)
.Skip(page * pagesize)
.Take(pagesize)
.ToList());
}
}
public IList <Comments> GetComments(int page, int pagesize)
{
using (var db = new Sova())
{
return(db.Comments
.OrderBy(c => c.id)
.Skip(page * pagesize)
.Take(pagesize)
.ToList());
}
}
