Hi,

How to catch and identify a duplicate key exception? I am using

        catch (Exception err)
        {
            MessageBox.Show("Database error \n" + err.Message,
                    "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
            return false;
        }

but it is too generic, could some body give me a hand?.

thanks,

It depends on the error message returned from the database. so you have to parse the erro message.

Something like this:

catch (Exception ex)
{
if(ex.Message.IndexOf("PRIMARY KEY constraint") >= 0)   
{
...
}
}

Also for more specialization you may handle the ORMQueryExecutionException and check the message written in the inner exception.