public Image GetImagebyId(int id) { using (var context = new imageuploadDataContext(_connectionString)) { return(context.Images.FirstOrDefault(p => p.Id == id)); } }
public IEnumerable <Image> GetImages() { using (var context = new imageuploadDataContext(_connectionString)) { return(context.Images.OrderByDescending(i => i.Id).ToList()); } }
public void Add(Image image) { using (var context = new imageuploadDataContext(_connectionString)) { context.Images.InsertOnSubmit(image); context.SubmitChanges(); } }
public void AddLike(int id) { using (var context = new imageuploadDataContext(_connectionString)) { var image = context.Images.FirstOrDefault(i => i.Id == id); image.LikeCount++; context.SubmitChanges(); } }