public int GetHighestId() { using (var context = new Images3DataContext(_connectionString)) { return(context.Images.OrderByDescending(i => i.Id).FirstOrDefault().Id); } }
public Images GetImageForId(int id) { using (var context = new Images3DataContext(_connectionString)) { return(context.Images.FirstOrDefault(i => i.Id == id)); } }
public IEnumerable <Images> GetAllImages() { using (var context = new Images3DataContext(_connectionString)) { return(context.Images.OrderByDescending(i => i.Id).ToList()); } }
public int GetLikesForId(int id) { using (var context = new Images3DataContext(_connectionString)) { Images image = context.Images.FirstOrDefault(i => i.Id == id); return(image.LikeCount); } }
public void AddImage(Images image) { using (var context = new Images3DataContext(_connectionString)) { context.Images.InsertOnSubmit(image); context.SubmitChanges(); } }
public void AddLikeForId(int id) { using (var context = new Images3DataContext(_connectionString)) { Images image = context.Images.FirstOrDefault(i => i.Id == id); image.LikeCount++; context.SubmitChanges(); } }