public void UpdatePersonTag(string faceId, string[] tags) { using (var db = new personrepositoryEntities()) { var haveTags = db.persontags.Where(s => s.FaceID == faceId).Select(s => s.TagName).ToArray(); var newTags = tags.Except(haveTags).ToArray(); foreach (var tag in newTags) { persontag pt = new Repository.persontag() { FaceID = faceId, TagName = tag }; db.persontags.Add(pt); } db.SaveChanges(); } }
public void AddPersonTag(string faceId, string[] tags) { using (var db = new personrepositoryEntities()) { //删除旧标签 var sql = "delete from persontags where faceid='" + faceId + "'"; var count = db.Database.ExecuteSqlCommand(sql); print("删除旧标签->" + count); foreach (var tag in tags) { persontag pt = new Repository.persontag() { FaceID = faceId, TagName = tag }; db.persontags.Add(pt); } db.SaveChanges(); } }