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.
Tag: Dapper
Generalize a method to read any master table with C# and Dapper
On a web page or application form, it is common to have different master data like Country, State…etc. available in dropdownlist, listbox or any other control. It is needed to read all master data from database and bind to proper controls. This post explains different ways to read master tables with C# and Dapper.
ASP.NET Core Identity and Role based Security
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:
PostgreSQL Enum, C# and Dapper
ASP.NET Core Identity: Add Roles on Application Startup
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
Npgsql 3.1.9
Dapper 1.50.2
Visual Studio 2015 update 3
Identity.Dapper