无法插入重复键 [英] Cannot insert duplicate key

问题描述

我得到这个错误...

PRIMARY KEY约束'PK_Members'的

 冲突。不能插入对象dbo.Members重复键。
该语句已终止。
 

当我尝试使用ASP.NET MVC成员资格和角色提供。调用从RoleProvider内的getUser方法，当它发生。

  VAR成员= System.Web.Security.Membership.GetUser（电子邮件）作为Models.Member;
        // VAR成员=（
        //从米DataContext.Members
        //其中m.Email ==电子邮件
        //选择M）。单（）;        VAR角色=（
            从DataContext.Rolesř
            其中，r.Name ==角色名
            选择R）。单（）;        member.Groups.Add（新Models.Group（角色））;        DataContext.SubmitChanges（）;
 

解决方案

它看起来像问题是在code

  member.Groups.Add（新Models.Group（角色））;
 

根据由SQL返回的错误消息，就像读的getUser操作不会抛出这种类型的错误。

I am getting this error ...

Violation of PRIMARY KEY constraint 'PK_Members'. Cannot insert duplicate key in object 'dbo.Members'.
The statement has been terminated.

When I try to use the Membership and Role Providers in ASP.NET MVC. It happens when calling the GetUser method from inside the RoleProvider.

        var member = System.Web.Security.Membership.GetUser(email) as Models.Member;
        //var member = (
        //    from m in DataContext.Members
        //    where m.Email == email
        //    select m).Single();

        var role = (
            from r in DataContext.Roles
            where r.Name == roleName
            select r).Single();

        member.Groups.Add(new Models.Group(role)); 

        DataContext.SubmitChanges();

解决方案

It looks like the problem is in the code

member.Groups.Add(new Models.Group(role));

Based on the error message returned by the sql, Read operation like GetUser won't throw this type of error.

这篇关于无法插入重复键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！