Remove Dataverse Relationship in C# Plugin

(0) Share

Report

Posted on by AnthonyD

559

Hello Community!

I have the following usecase: A Trainee get's deleted from a Training. That training has Extra Costs which are related to the Trainee. On deleting the Trainee from the Training the Trainee should get unrelated from his Extra Costs (which doesn't happen now). Is it possible in C# syntax to unrelate Extra Cost ID from TraineeID?

This is how the relations are build:

Training 1:M Extra Costs
Trainee M:M Extra Costs

Best Regards,

Anthony

All responses (1)

Answers (1)

Verified answer

AnthonyD 559 on at

Like (0)

Report
Re: Remove Dataverse Relationship in C# Plugin

Somehow it was easier then i expected. Here is where i found the solution:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/org-service/entity-operations-associate-disassociate

And this is the code i used (it compares 2 collections and adds the matching ounces to a collection. These are the ounces to unrelate)
double traineeExtraKostKost=0; EntityCollection TraineeExtraKostsCollection = new EntityCollection(); foreach (var extrakost in opleidingExtraKostResult.Entities) { foreach (var traineeExtraKost in cursistExtraKosts.Entities) { if (traineeExtraKost.Id==extrakost.Id) { traineeExtraKostKost += Convert.ToDouble(traineeExtraKost.Attributes.FirstOrDefault(q => q.Key == "cref8_prijs").Value); TraineeExtraKostsCollection.Entities.Add(extrakost); } } } var extraKostReference = new EntityReferenceCollection(); TraineeExtraKostsCollection.Entities.ToList().ForEach(x => { extraKostReference.Add(x.ToEntityReference()); }); var relationship = new Relationship("cref8_ExtraKost_cref8_Cursist_cref8_Cursi"); service.Disassociate("cref8_cursist", relatedEntity.Id, relationship, extraKostReference);

Best Regards,
Anthony