bit Boilerplate IdentityController needs performance improvements

[ysmoradi]

Problem

The IdentityController has inefficient authentication patterns:

1. Redundant database lookups: Using PasswordSignInAsync(userName, password, ...) causes extra FindByNameAsync queries when we already have the user object
2. Unnecessary UserManager.UpdateAsync: Calling UpdateAsync before SaveChangesAsync adds redundant validation and database round-trips when only updating TwoFactorTokenRequestedOn
3. Inefficient security stamp validation: ValidateSecurityStampAsync(principal) makes extra database queries to fetch the user we already have from the session query

Impact: Multiple unnecessary database queries per authentication request, reduced performance

[github-actions]

Hello there! I'm a wiki 🤖.

Based on the content of this thread, I've found a potentially relevant wiki page for you!

✨ View Wiki Page

I hope this helps!