How to delete rows of two different table having same id mvc

I am doing a project and in that I two table agent and user. The user table contains a foreign key called agentid which takes the value from the id of the agent table. so here I need to delete an agent in the agent table and at the same time it must effect to the user table and must delete the row in the user table that having the same id of the agent that was deleted. eg, suppose if i deleted agent 10 , all the details in the id 10 must be deleted along with that the agentid with 10 in the user table must also be deleted. when I simply delete the agent in agent table, it generates an error that

The DELETE statement conflicted with the REFERENCE constraint

I dont know how to solve my problem and my code is

[HttpPost, ActionName("Delete")]

[ValidateAntiForgeryToken]

public async Task<ActionResult> DeleteConfirmed(int id)

{

AgentMaster agentMaster = await db.AgentMasters.FindAsync(id);

db.AgentMasters.Remove(agentMaster);

await db.SaveChangesAsync();

return RedirectToAction("Index");

}

This is my controller part, when I tried with join the table and delete the record it always shows the same error . Can anyone please help me to find a solution for my problem ?????

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ehsan Sajjad9y ago
Accepted answer
The row which you are trying to delete is referenced in another child table due to which databases is not allowing to delete the parent record, you would have to enable cascade deletion or first delete the row from child table, then from the parent table.

Hope it helps.
Ehsan Sajjad9y ago
The same way you are doing for master, first find the row in child table and delete it, then delete from that master table.