DEV Community

Dominic Robinson
Dominic Robinson

Posted on

Building a Production-Ready ASP.NET Core Identity System with MySQL


Authentication is one of the most critical and most commonly misconfigured layers of any web application. Yet in the .NET ecosystem, many developers still build user registration and login flows from scratch โ€” introducing inconsistencies, security gaps, and weeks of avoidable rework.

To solve this, I built and open-sourced aspnet-core-2.1-user-registration-login-application: a fully scaffolded, production-ready C# membership system built on ASP.NET Core 2.1 with MySQL as the backend โ€” designed to serve as a reusable foundation for any web application requiring identity management.

๐Ÿ‘‰ View the Repository on GitHub


The Problem: Identity Is Hard to Get Right

Every enterprise web application needs identity. But most teams either:

  • Roll their own authentication โ€” risking security vulnerabilities through improper password hashing, session mismanagement, or insecure token storage
  • Spend days configuring ASP.NET Core Identity from scratch, fighting Entity Framework migrations, and wiring up database providers
  • Rely on third-party SaaS identity solutions that introduce vendor lock-in and ongoing cost

What the .NET community has long needed is a clean, open, fully functional reference implementation that teams can fork, configure, and ship โ€” not documentation to read, but code to run.


What the Project Delivers

This is a complete, end-to-end C# ASP.NET Core Razor Pages membership application, pre-wired with ASP.NET Core Identity and MySQL via Entity Framework Core. It provides an immediate, working baseline for any application requiring authenticated access.

Core Features

User Registration โ€” New users can self-register with email and password. Passwords are hashed using ASP.NET Core Identity's PasswordHasher, which implements PBKDF2 with HMAC-SHA256 โ€” industry-standard, not a custom implementation.

User Login โ€” Secure session-based authentication using encrypted cookies. The login flow validates credentials against the Identity store, handles failed attempts gracefully, and persists sessions across requests.

Forgot/Reset Password โ€” A complete password recovery flow, including token generation, email-based reset links, and secure token validation on submission. This is one of the most error-prone flows to build manually โ€” it's done correctly here out of the box.

User Dashboard โ€” An authenticated area accessible only to logged-in users, demonstrating route-level authorization guards using [Authorize] attributes โ€” a pattern directly transferable to any real application.

Admin Area โ€” A separate AdminApp module with its own solution structure, demonstrating area-based authorization and multi-role access control separation.


Architecture & Technical Decisions

ASP.NET Core Identity + MySQL โ€” A Non-Trivial Integration

By default, Microsoft's Identity scaffolding assumes SQL Server. Wiring it to MySQL requires explicit configuration of the Pomelo MySQL provider for Entity Framework Core โ€” a choice made deliberately here to widen applicability to teams running open-source database stacks, cloud-hosted MySQL (AWS RDS, Azure Database for MySQL, PlanetScale), or self-hosted environments.

The connection string abstraction in appsettings.json means the same codebase runs against local, staging, or production databases without code changes:

"ConnectionStrings": {
  "DefaultConnection": "server=127.0.0.1;port=3306;database=db-name;uid=db-user;password=db-password"
}
Enter fullscreen mode Exit fullscreen mode

This environment-agnostic configuration is a prerequisite for CI/CD-ready, containerizable applications.

Entity Framework Core Migrations โ€” Code-First Database Management

Rather than shipping a SQL dump, the project uses EF Core's code-first migration model. The database schema is generated and versioned in C# โ€” giving developers full schema control through source-controlled migration files.

Getting started is a three-command sequence:

# Step 1 โ€” Delete the existing Migrations folder (to regenerate for your DB)

# Step 2 โ€” Generate migrations
PM> Add-Migration InitialCreate

# Step 3 โ€” Apply to the database
PM> Update-Database
Enter fullscreen mode Exit fullscreen mode

This approach means schema changes are trackable, reversible, and deployable as part of any standard release pipeline.

Razor Pages โ€” Clean MVC Without the Overhead

The application uses Razor Pages over the traditional MVC controller/view split โ€” a deliberate architectural choice that co-locates page logic with its view, reduces boilerplate, and maps more directly to the feature-centric folder structure modern teams prefer.

Each page has a corresponding PageModel class with clearly separated OnGet and OnPost handlers โ€” making the codebase readable, testable, and easy to extend.

Admin/User Separation via ASP.NET Core Areas

The project separates the AdminApp from the standard user-facing application using ASP.NET Core Areas โ€” a clean pattern for multi-role systems where administrators and end users interact with entirely different surfaces of the same application, without sharing controllers, views, or routing.


Solution Structure

aspnet-core-2.1-user-registration-login-application/
โ”œโ”€โ”€ AdminApp/               # Admin area with separate routing
โ”‚   โ”œโ”€โ”€ Controllers/
โ”‚   โ”œโ”€โ”€ Models/
โ”‚   โ”œโ”€โ”€ Views/
โ”‚   โ””โ”€โ”€ Areas/
โ”œโ”€โ”€ .vs/                    # VS solution config
โ”œโ”€โ”€ AdminApplication.sln    # Solution file
โ””โ”€โ”€ README.md
Enter fullscreen mode Exit fullscreen mode

Language breakdown: C# 94.2% ยท HTML 5.7% โ€” reflecting that this is principally a server-side application with Razor-rendered views, not a JavaScript-heavy SPA.


Why Open Source?

Enterprise authentication patterns should not be proprietary knowledge. The patterns implemented in this project โ€” secure session management, EF Core migrations, area-based authorization, MySQL integration โ€” are patterns that junior and mid-level .NET developers encounter on almost every project, yet spend significant time rediscovering.

By releasing this as a reusable open-source scaffold, the goal is to:

  • Save teams days of configuration that add no business value
  • Prevent common security mistakes by providing a correct-by-default implementation
  • Serve as a living reference for best practices in ASP.NET Core identity management
  • Accelerate onboarding โ€” new developers can read this codebase to understand how Identity, EF Core, and Razor Pages fit together in a real application

The project has been starred and forked by developers globally, validating its utility as a community resource.


Who Should Use This

Use Case How It Helps
New .NET web projects Skip identity setup, ship features faster
Learning ASP.NET Core Identity See a complete, working implementation
MySQL + .NET integration Reference for Pomelo EF Core MySQL provider setup
Multi-role web apps Admin/User area separation pattern
Rapid prototyping Working auth in minutes, not days

Extending the Template

The scaffold is intentionally minimal โ€” it's a starting point, not a framework. Common extensions teams add from here include:

  • OAuth2 / Social Login โ€” Adding Google, GitHub, or Microsoft login via AddAuthentication().AddGoogle()
  • Two-Factor Authentication (2FA) โ€” ASP.NET Core Identity has built-in TOTP support ready to enable
  • Email Verification โ€” Token-based email confirmation on registration
  • Role-Based Access Control (RBAC) โ€” Extending the [Authorize(Roles = "Admin")] pattern to granular permission sets
  • JWT API Authentication โ€” Adding a parallel API surface alongside the Razor Pages UI

Get Started in 5 Minutes

# 1. Clone the repo
git clone https://github.com/robinsondominic/aspnet-core-2.1-user-registration-login-application

# 2. Open AdminApplication.sln in Visual Studio

# 3. Update appsettings.json with your MySQL connection string

# 4. In Package Manager Console:
Add-Migration InitialCreate
Update-Database

# 5. Run the application โ€” login and register pages are live
Enter fullscreen mode Exit fullscreen mode

Get Involved

This is an open-source project and contributions are welcome โ€” whether that's adding features, improving documentation, or raising issues for discussion.

๐Ÿ‘‰ aspnet-core-2.1-user-registration-login-application on GitHub

If this saved you setup time or served as a useful reference, a โญ on the repo goes a long way in helping others find it.


Building .NET identity systems and have patterns worth sharing? Drop them in the comments โ€” let's build a stronger open-source .NET community together. ๐Ÿ‘‡

#dotnet #csharp #aspnetcore #webdev #opensource #mysql #authentication #identity #backend #programming

Top comments (0)