public void Add(UploadedPicture picture)
{
using (var context = new PicturesDBDataContext(_connection))
{
context.UploadedPictures.InsertOnSubmit(picture);
context.SubmitChanges();
}
}
public void TimesSeen(int id)
{
using (var context = new PicturesDBDataContext(_connection))
{
UploadedPicture image = context.UploadedPictures.FirstOrDefault(i => i.id == id);
image.TimesSeen = image.TimesSeen + 1;
context.SubmitChanges();
}
}