public void Add(Images entity) { try { using (var db = new DataImageDataContext()) { var table = db.GetTable<Images>(); table.InsertOnSubmit(entity); db.SubmitChanges(); } } catch (Exception ex) { _logger.Error(ex.Message); } }
static void Main(string[] args) { Console.WriteLine("上传图片"); var nvc = new NameValueCollection {{"deviceId", "2"}}; var result = ImageClient.Upload(@"C:\Users\Administrator\Desktop\公共数据库系统建设\新建文件夹\slide_02.png", new NameValueCollection()); Console.WriteLine(result); Console.WriteLine("写入数据库"); var entity = new Images { ImageUrl = result.ImageUrl, }; var providre = new ImageDataRepository(); providre.Add(entity); Console.ReadLine(); }
public void Update(Images entity) { try { using (var db = new DataImageDataContext()) { var oldEntity = db.GetTable<Images>().First(p => p.Id == entity.Id); oldEntity.Name = entity.Name; oldEntity.ImageUrl = entity.ImageUrl; oldEntity.CompressUrl = entity.CompressUrl; oldEntity.ThumbUrl = entity.ThumbUrl; db.SubmitChanges(); } } catch (Exception ex) { _logger.Error(ex.Message); } }
partial void DeleteImages(Images instance);
partial void UpdateImages(Images instance);
partial void InsertImages(Images instance);