A Blog full of Web Projects

6 projects tagged with "mssql"

  • .NET 8 and Umbraco 13 CMS serving my Personal Website

    29-July-2026

    My Personal Website by Umbraco 13 CMS and .NET 8 using a MSSQL Database for both Development and Production

    Try the demo...

    This Website was created by Umbraco 13 CMS, .NET 8, a MSSQL Database and hosted at a tradiotional Web Hotel using IIS. The Umbraco Version 13 has a mobile friendly Backoffice which I wanted for my Website

    The source code at GitHub
  • .NET 10 and ASP.NET Core MVC Web Application

    03-June-2026

    ASP.NET Core MVC Web App using .NET 10 - A Starter with CRUD functionality of Employees

    Traditional webhosting is used for this Application

    An ASP.NET Core MVC Web App created by VS Code using .NET 10 serving CRUD functionality of Employees towards a MSSQL Database

    Below is a .NET 8 version of the Web App


  • .NET 8 REST API Membership system + Email verification - Azure and GH Pages

    07-January-2026

    .NET 8 REST API at Azure with C# using Entity Framework Core + MSSQL consuming an Angular 14 Client at GH Pages - serving as a Membership System

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 30 seconds!

    Unit Testing:

    • Karma + Jasmine - Used with the Angular Client

    Try the demo...

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Functionality of the Web App

    • JWT authentication with Refresh Tokens
    • Refresh token rotation
    • Revoked token reuse detection
    • Email sign up and verification
    • Forgot password and reset password functionality
    • Role based authorization with two roles "User" and "Admin"
    • CRUD Account management routes with role based access control

    Tech used for building the Web App

    • C#
    • The .NET 8 Web API is hosted at Azure App Service
    • DevOps by Azure App Service + Repos for the .NET 8 Web API
    • The Angular Client is hosted at GH Pages
    • DevOps by GitHub Actions + Pages for the Angular Client
    • MSSQL as the Database for both Dev + Prod
    • CORS Policy implemented by .NET
    • JWT Token for access secure routes
    • Refresh Token by HTTP only Cookie to generate new JWT Tokens
    • Swagger API documentation with routes

  • .NET 6 REST API Membership system using MSSQL

    15-March-2024

    .NET 6 REST API with C# using Entity Framework Core + Remote MSSQL for Prod + local SQLite DB for Dev consumed by a Blazor Client serving as a Membership System

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Try the demo...

    - C#
    - Registration of Users
    - JWT authentication
    - CRUD Account management

    MSSQL Server is fine for Production

    SQLite is local DB and fine for testing locally and small applications

    Traditional webhosting is used for this Application


  • .NET Core 2.2 REST API Role based Membership system

    07-October-2023

    ASP.NET Core 2.2 REST API with C# towards Angular and React serving as Role based Membership system

    Traditional webhosting is used for this Application

    A Web API role based Membership System for authentication and registration managing Users by an Angular or React client / ASP.NET Core 2.2 Web API with C# secured by HTTPS and Authentication by a JWT

    Administrate Posts by an Angular client and the Web API after a successfully login


  • .NET Core 2.0 MVC and REST API with Crud functionality

    15-January-2023

    ASP.NET Core 2.0 REST API with C# showing a dataset of Persons by MVC / Web API

    Traditional webhosting is used for the Application

    Try the demo...

    Showing / Administrate a dataset of persons as a REST API + MVC using C#, MSSQL Database, AngularJS, ReactJS, jQuery, Ajax and JSON dataset. Secured by HTTPS

    The source code at GitHub
Software Developer - Per Olsen - Denmark