Asp net mvc 5 authentication with mysql database

As a Proof of Concept, I created an ASP.NET MVC Core Identity Server project that acts as a Single Sign-On Application for any type of Web-based Authentication system.

An ASP.NET MVC Core Web Application built using ASP.NET MVC Core, .NET Core 2.0, IdentityServer4 and Entity Framework Core for MySQL database provider.

ASP.NET MVC Core

.NET Core 2.0 enables the deployment and running of ASP.NET MVC applications on servers other than Windows Server platforms running IIS. In this case, it runs on a MacBook running an Apache web server with a local MySQL database instance.

Database Platform

Until recently, I have always felt the only reliable and cost-efficient database for smaller to mid-sized projects to be Microsoft SQL Server. This proof of concept project makes it clear that the MySQL database engine and Entity Framework Core are playing very well together and are sufficiently mature to serve most small to mid-sized authentication gateway, servicing ASP.NETMVC Core applications, Web API application as well as mobile and desktop applications..

Single Sign On with OpenID and IdentityServer4

Registering Applications

…

Validating Mobile Users

A sample Xamarin Forms app provides an excellent example of how to authenticate against the single sign on server using…

Validating Web Users

We can validate web users using the sample ASP.NET MVC application and …

Validating API Access

Project Source Code

The working copy of this project’s code can be found here.

Software Licensing

I do have a variety of Open Source projects that I work on when I have time. These include some example code as well as a personal budgeting application designed for Android, iOS and UWP mobile devices.

I use the Apache License 2.0 for most Open Source projects. I’m open to other  licenses as warranted.