实体框架中的重复键异常? [英] Duplicate key exception from Entity Framework?

问题描述

当我将具有给定用户名的现有用户插入我的数据库时，我试图捕捉抛出的异常.正如标题所说，我正在使用EF.当我尝试将用户插入 db 时引发的唯一异常是UpdateException" - 如何提取此异常以确定它是重复异常还是其他异常?

I'm trying to catch the exception thrown when I insert a already existing user with the given username into my database. As the title says then I'm using EF. The only exception that's thrown when I try to insert the user into to db is a "UpdateException" - How can I extract this exception to identify whether its a duplicate exception or something else?

推荐答案

catch (UpdateException ex)
{
    SqlException innerException = ex.InnerException as SqlException;
    if (innerException != null && innerException.Number == ??????)
    {
        // handle exception here..
    }
    else
    {
        throw;
    }
}

在 ?????? 处输入与唯一约束违规相对应的正确数字(我完全不知道).

Put the correct number at ?????? that corresponds to unique constraint violation (I don't know it from the top of my head).

这篇关于实体框架中的重复键异常?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！