public IEnumerable<image> GetImgs()
{
using (var ctx = new ImgMetadataDbCon())
{
return ctx.images.Include("repository").ToList();
}
}
public long GetImgsCount()
{
using (var ctx = new ImgMetadataDbCon())
{
return ctx.images.Count();
}
}
public IEnumerable<image> GetImgs(int pageNum, int pageSize)
{
using (var ctx = new ImgMetadataDbCon())
{
int toSkip = 0;
if (pageNum > 1)
{
toSkip = (pageNum - 1) * pageSize;
}
return ctx.images.Include("repository").OrderByDescending(im => im.Id).Skip(toSkip).Take(pageSize).ToList();
}
}