public static int Add(List <string> userCodes, string relationsTable, string relationsKey) { using (pm2Entities entities = new pm2Entities()) { foreach (Basic_Privilege privilege in (from m in entities.Basic_Privilege where (m.RelationsTable == relationsTable) && (m.RelationsKey == relationsKey) select m).ToList <Basic_Privilege>()) { entities.DeleteObject(privilege); } if (userCodes != null) { foreach (string str in userCodes) { string str2 = Guid.NewGuid().ToString(); Basic_Privilege privilege2 = new Basic_Privilege { PrivilegeId = str2, RelationsTable = relationsTable, RelationsKey = relationsKey, UserCode = str }; entities.AddToBasic_Privilege(privilege2); } } return(entities.SaveChanges()); } }
public void Add(string table, string key, IList <string> userCodes) { using (pm2Entities entities = new pm2Entities()) { using (IEnumerator <string> enumerator = userCodes.GetEnumerator()) { string code; while (enumerator.MoveNext()) { code = enumerator.Current; if ((from p in entities.Basic_Privilege where ((p.RelationsTable == table) && (p.RelationsKey == key)) && (p.UserCode == code) select p).Count <Basic_Privilege>() == 0) { Basic_Privilege entity = new Basic_Privilege { PrivilegeId = Guid.NewGuid().ToString(), RelationsTable = table, RelationsKey = key, UserCode = code }; entities.Basic_Privilege.AddObject(entity); } } } entities.SaveChanges(); } }