• Sql server 2014
• Visual Studio

• Crud for blog post and users
• API for query content of published post

• MVC .Net Core template.
• EntityFramework Core for CRUD Model, controller and views.

git clone https://github.com/neojavan/blogpostTest

Import the sql file into your database. You could do it on Sql Server Management Studio or by cmd with admin privilege

Publish the solution from the visual studio to your local IIS or Azure

• // GET: api/Posts Query the posts pending of being published status 1 submit pending 2 reject 3 publish 4 delete