Home / Questions / 20887
Accepted
Antonio
Asked: 2020-08-18 13:13:09 +0800 CST 2020-08-18 13:13:09 +0800 CST

How do I know without a "remove" in my controller it was rejected because of a foreign key violation?

  • 772

How to tell the user that a record has not been deleted because it has other entities to which it inherits its primary key via try/catch?

try
{
    db.usuarios.Remove(usuario);
}
catch(?????)
{
    ???????
}
c#

1 Answers

  1. Best Answer

    If you don't have cascading delete enabled you should handle the exception using something like be

    try
{
    db.usuarios.Remove(usuario);
}
catch (DbUpdateException ex)
{
    var sqlException = ex.GetBaseException() as SqlException;

    if (sqlException != null)
    {

    }
}

    Cannot catch SqlException in Entity Framework

    by getting the sql exception you could loop through the errors and validate the Numberto determine if there are any related toForeign Key violation

    • 1