Hello. I am create audit history of a record by clone the object, but when I called SaveChange, I got the error Unable to determine the principal end of the 'ISTS.Core.Context.FK_SYS_GROUP_USER_USER_ID' relationship. Multiple added entities may have the same primary key, here is my code
var auditRecord = new SYS_USER()
{
SYS_TRAN_ID = 1195358,
AUDIT_FIELDS = null,
AUDIT_OPERATION = "I",
APPROVAL_STATUS = "I",
UPD_SEQ = 0,
AMND_STATE = "A",
USER_ID = "phongbv",
USER_NAME = "Bui Van Phong",
DEPT_ID = 883,
PASS_CODE = "CEEA23519F6F86AD67E9F798BF8002CB",
STATUS = "A",
EFFECTIVE = DateTime.Now,
LAST_LOGIN = null,
EXPIRY = null,
TRY_COUNT = null,
MAX_CONNECTIONS = null,
USER_LEVEL = "9",
LDAP_ID = null,
AUTO_AUTHORIZED = 0,
SID = 61726161,
INHERIT_MENU_ACL = 1,
USER_GROUPS = new List<SYS_GROUP_USER>()
{
new SYS_GROUP_USER()
{
GROUP_ID = 224,
SID = 61726162,
AMND_STATE = "A",
}
}
};
var finalRecord = new SYS_USER()
{
SYS_TRAN_ID = 1195358,
AUDIT_FIELDS = null,
AUDIT_OPERATION = "I",
APPROVAL_STATUS = "I",
UPD_SEQ = 0,
AMND_STATE = "F",
USER_ID = "phongbv",
USER_NAME = "Bui Van Phong",
DEPT_ID = 883,
PASS_CODE = "CEEA23519F6F86AD67E9F798BF8002CB",
STATUS = "A",
EFFECTIVE = DateTime.Now,
LAST_LOGIN = null,
EXPIRY = null,
TRY_COUNT = null,
MAX_CONNECTIONS = null,
USER_LEVEL = "9",
LDAP_ID = null,
AUTO_AUTHORIZED = 0,
SID = 61726161,
INHERIT_MENU_ACL = 1,
USER_GROUPS = new List<SYS_GROUP_USER>()
{
new SYS_GROUP_USER()
{
GROUP_ID = 224,
SID = 61726162,
AMND_STATE = "F",
}
}
};
AppContext.TransactionContext.SYS_USER.Add(auditRecord);
AppContext.TransactionContext.SYS_USER.Add(finalRecord);
AppContext.TransactionContext.SaveChanges();