public Image GetImage(int id)
{
using (var context = new ImageDataContext(_connectionString))
{
return(context.Images.FirstOrDefault(i => i.Id == id));
}
}
public IEnumerable <Image> GetImages()
{
using (var context = new ImageDataContext(_connectionString))
{
return(context.Images.OrderByDescending(i => i.Id).ToList());
}
}
public void AddImage(Image image)
{
using (var context = new ImageDataContext(_connectionString))
{
context.Images.InsertOnSubmit(image);
context.SubmitChanges();
}
}
public void AddLike(int id)
{
using (var context = new ImageDataContext(_connectionString))
{
Image image = GetImage(id);
image.Likes = image.Likes + 1;
context.Images.Attach(image);
context.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, image);
context.SubmitChanges();
}
}