This article shows how to use PostgreSQL with ASP.NET Core 1.0 using Dapper ORM. We will implement CRUD (Create, Read, Update and Delete) operations in ASP.NET MVC step by step.
Do you want to allow user to login with either Username or Email address? ASP.NET Identity uses Username for Signin verification and In default Core template, Email is used as Username. In this post, we will change ASP.NET Core Identity setup to allow both Username and Email on login.
1. Username is unique for each user. It is either input by user or generated by application on registration.
2. No @ symbol allowed in Username.
In previous post, we created enum for different roles and added them in database on application startup. In this post, we will implement role based security.
It uses following environment:
In ASP.NET Core application, you want to seed roles and users in the database. This post explains how to add Roles on application startup using ASP.NET Core Identity. It is written in following environment:
ASP.NET Core 1.0.1
Postgresql 9.5.4 database
Visual Studio 2015 update 3