Question

How can I limit the UserName field in the table AspNetUsers?

Neither this:

public class ApplicationUser : IdentityUser
{
    [Required, MaxLength(15)]
    public string UserName { get; set; }

}

or this:

modelBuilder.Entity<ApplicationUser>().Property(x => x.UserName).HasMaxLength(15);

works.

I need this because setting an Index on an nvarchar(max) gives me this error msg:

Column 'UserName' in table 'dbo.AspNetUsers' is of a type that is invalid for use as a key column in an index.

To be verbose, I was trying to set the indexes like this:

public override void Up()
{
    CreateIndex("dbo.AspNetUsers", "UserName", true, "IX_UserName");
}

public override void Down()
{
    DropIndex("dbo.AspNetUsers", "IX_UserName");
}
1
8
2/23/2014 10:47:20 PM

Accepted Answer

In the latest version released today, this should do the trick:

modelBuilder.Entity<ApplicationUser>().Property(x => x.UserName).HasMaxLength(15);

5
3/20/2014 11:36:11 PM

Popular Answer

A lot of time has passed, but I think someone may still find it useful. I've had the same problem and found a clue to my solution here. The migration mechanisms ignore the MaxLength attribute, but one can add the corrections manually:

public override void Up()
{
    AlterColumn("dbo.AspNetUsers", "UserName", c => c.String(nullable: false, maxLength: 15, storeType: "nvarchar"));
    CreateIndex("dbo.AspNetUsers", "UserName");
}

public override void Down()
{
    DropIndex("dbo.AspNetUsers", new[] { "UserName" });
    AlterColumn("dbo.AspNetUsers", "UserName", c => c.String(nullable: false, maxLength: 256, storeType: "nvarchar"));
}

After update-database the fields are shortened and the SQL queries searching by UserName run faster (at least with mySQL which I use), because the indexes are used to search efficiently.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow