public int GetLikes(int id) { using (var context = new ImagesDataContext(_connectionString)) { return(context.Images.Where(i => i.Id == id).Select(i => i.Likes).FirstOrDefault()); } }
public void AddLike(int id) { using (var context = new ImagesDataContext(_connectionString)) { context.ExecuteCommand("UPDATE Images SET Likes = Likes + 1 WHERE Id = {0}", id); } }
public Image GetImage(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.OrderByDescending(i => i.DateUploaded).ToList()); } }
public void Add(Image image) { using (var context = new ImagesDataContext(_connectionString)) { context.Images.InsertOnSubmit(image); context.SubmitChanges(); } }