来自实体框架的重复键异常?

问题描述

当我将具有给定用户名的现有用户插入到我的数据库中时，我试图捕获抛出的异常.正如标题所说，我正在使用 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).

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