service.Associate("invoice", entityReferenceInvoice.Id,

new Relationship("new_invoice_new_contact20220111"), entityReferenceCollectionContact);

添加多对多的记录

service.Associate("当前entity","当前entityid","关系表名称","记录集合")

QueryExpression userque = new QueryExpression("systemuser");

userque.ColumnSet = new ColumnSet(true);

userque.Criteria.FilterOperator = LogicalOperator.And;

userque.Distinct = true;

//外键表名，用户id，外键表中的用户id

LinkEntity link = userque.AddLink("systemuserroles", "systemuserid", "systemuserid", JoinOperator.Inner);

link.EntityAlias = "Role";

//外键表名，角色id，外键表中的角色id

LinkEntity roleLink = link.AddLink("systemuserroles", "roleid", "roleid", JoinOperator.Inner);

//roleLink.Columns.AddColumn("name");

//userque.Criteria.AddCondition("country", "new_name", ConditionOperator.Equal, "United States");

//查用户中id等于excel的用户

userque.Criteria.AddCondition("systemuserid", ConditionOperator.Equal, entityUser.Id.ToString());

roleLink.LinkCriteria.AddCondition("roleid", ConditionOperator.Equal, entityCollectionRole.Entities[0].Id.ToString());

EntityCollection systemUserRoles = server.RetrieveMultiple(userque);

//判断用户是否有此角色

if(systemUserRoles.Entities.Count == 0)

{

//没有角色的话添加

server.Associate("systemuser", entityUser.Id, new Relationship("systemuserroles_association"), new EntityReferenceCollection() { new EntityReference("role", entityCollectionRole.Entities[0].Id) });

taskContext.Logger.ConsoleInfo($"已为“" + userName + "”添加“"+ item + "”角色");

}