Exemple #1
0
        public IList <Post> Posts(int pageNo, int pageSize)
        {
            var posts = _dbContext.Set <Post>()
                        .Where(p => p.Published)
                        .OrderByDescending(p => p.PostedOn)
                        .Skip(pageNo * pageSize)
                        .Take(pageSize)
                        .Include(p => p.Category)
                        .ToList();

            var postIds = posts.Select(p => p.Id).ToList();

            return(_dbContext.Set <Post>()
                   .Where(p => postIds.Contains(p.Id))
                   .OrderByDescending(p => p.PostedOn)
                   .Include(p => p.Tags)
                   .ToList());
        }
 public BlogService(IBlogContext context, IMapper mapper)
 {
     _context    = context;
     _repository = _context.Set <Blog>();
     _mapper     = mapper;
 }
 public void Create(T item)
 {
     _database.Set <T>().Add(item);
     _database.SaveChanges();
 }