ASP.NET SqlMembershipProvider: Unique but not required email?

Question

Is there a way to configure ASP.NET SqlMembershipProvider such that Email is optional but when provided must be unique?

I only found the requiredUniqueEmail attribute (web.config) which makes Email mandatory. Do I have to leave this out and implement checking for existing email addresses myself in the account registration process?

Or is there a nicer way to handle this scenario?

score 2 · Accepted Answer · answered Nov 16 '10 at 16:37

An easy, but probably risky way, is to modify the stored procedure directly to do this.

Modify aspnet_Membership_CreateUser by replacing:

IF (@UniqueEmail = 1)
BEGIN
    IF (EXISTS (SELECT *
                FROM  dbo.aspnet_Membership m WITH ( UPDLOCK, HOLDLOCK )
                WHERE ApplicationId = @ApplicationId AND LoweredEmail = LOWER(@Email)))
    BEGIN
        SET @ErrorCode = 7
        GOTO Cleanup
    END
END

with

    IF (EXISTS (SELECT *
                FROM  dbo.aspnet_Membership m WITH ( UPDLOCK, HOLDLOCK )
                WHERE ApplicationId = @ApplicationId AND LoweredEmail = LOWER(@Email)))
    BEGIN
        SET @ErrorCode = 7
        GOTO Cleanup
    END

I say it's risky because nobody would expect you to modify this and you'd better document the change well.

Seems to be the "simplest" solution. Thanks. – davehauser Nov 28 '10 at 13:26 — davehauser, Nov 28 '10 at 13:26

ASP.NET SqlMembershipProvider: Unique but not required email?

1 Answers1