public Image GetById(int id)
{
using (var context = new ImagesDataContext(_connectionString))
{
return(context.Images.FirstOrDefault(i => i.Id == id));
}
}
public IEnumerable <Image> GetImages()
{
using (var context = new ImagesDataContext(_connectionString))
{
return(context.Images.ToList().OrderByDescending(i => i.Id));
}
}
public void AddImage(Image image)
{
using (var context = new ImagesDataContext(_connectionString))
{
context.Images.InsertOnSubmit(image);
context.SubmitChanges();
}
}
public void IncrementLikeCount(int imageId)
{
using (var context = new ImagesDataContext(_connectionString))
{
Image image = context.Images.FirstOrDefault(i => i.Id == imageId);
image.LikeCount++;
context.SubmitChanges();
}
}