Use XRM tooling to delete data
Note
Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.
There are two methods available in the CrmServiceClient class for deleting data in Microsoft Dataverse: DeleteEntity(String, Guid, Guid) and DeleteEntityAssociation(String, Guid, String, Guid, String, Guid).
DeleteEntity
DeleteEntity is used to remove a single row of data from Dataverse. To use this method, you need to know the table schema name you wish to affect, and the GUID of the row you want to remove.
CrmServiceClient svc = new CrmServiceClient(connectionstring);
// Verify that you are connected
if (svc != null && svc.IsReady)
{
// Delete the entity record
svc.DeleteEntity("account", <accountId>);
}
else
{
// Display the last error.
Console.WriteLine("An error occurred: {0}", svc.LastCrmError);
// Display the last exception message if any.
Console.WriteLine(svc.LastCrmException.Message);
Console.WriteLine(svc.LastCrmException.Source);
Console.WriteLine(svc.LastCrmException.StackTrace);
return;
}
DeleteEntityAssociation
DeleteEntityAssociation removes the many-to-many association between records in tables. In this example, we will remove the association between a record in the lead and account tables.
CrmServiceClient svc = new CrmServiceClient(connectionstring);
// Verify that you are connected
if (svc != null && svc.IsReady)
{
Guid accountId = new Guid("<Account_GUID>");
Guid leadId = new Guid("<Lead_GUID>");
string accountLeadRelationshipName= "accountleads_association";
svc.DeleteEntityAssociation("account" , accountId, "lead" , leadId, accountLeadRelationshipName)
}
else
{
// Display the last error.
Console.WriteLine("An error occurred: {0}", svc.LastCrmError);
// Display the last exception message if any.
Console.WriteLine(svc.LastCrmException.Message);
Console.WriteLine(svc.LastCrmException.Source);
Console.WriteLine(svc.LastCrmException.StackTrace);
return;
}
See also
Sample: Quick start for XRM Tooling API
Use XRM Tooling to connect to Dataverse
Use XRM Tooling API to execute actions in Dataverse