Aspnetcore.docs: What is the purpose of NormalizedX columns in Identity tables?

[dehghani-mehdi]

Hi,

EF create tables for identity, in some tables there are NormalizedX columns, e.g: NormalizedName in AspNetRoles table.

1. What is the purpose of this kind of columns?
2. How EF normalize data for this columns?

I didn't find any documentation about this topic.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 94bfd895-d2af-390b-0801-428b36a27ff4
• Version Independent ID: 0e0d870e-e49a-e16c-c259-68d58e701b8f
• Content: Introduction to Identity on ASP.NET Core
• Content Source: aspnetcore/security/authentication/identity.md
• Product: aspnet-core
• Technology: aspnetcore-security
• GitHub Login: @Rick-Anderson
• Microsoft Alias: riande

[Rick-Anderson]

Good question. I'll try to get an answer. In the mean time, moved to Master issue: Introduction to Identity #16230

[Rick-Anderson]

@HaoK What is the purpose of NormalizedX columns in Identity tables?

EF create tables for identity, in some tables there are NormalizedX columns, e.g: NormalizedName in AspNetRoles table.

1. What is the purpose of this kind of columns?
2. How EF normalize data for this columns?

[HaoK]

The normalized fields are what we do comparisons against for lookups, the regular columns are what you can think of as the display names, so the casing is preserved.

[dehghani-mehdi]

@HaoK what about second question?

[HaoK]

EF doesn't normalize the column at all, the user manager uses the ILookupNormalizer interface that by default just calls to upper invariant I believe