A Blog full of Web Projects

5 projects tagged with "ms-sql"

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

    25-November-2024

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

    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
    • MS SQL 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 - MS SQL

    15-March-2024

    .NET 6 REST API with C# using Entity Framework Core + Remote MS SQL 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

    MS SQL 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#, MS SQL Database, AngularJS, ReactJS, jQuery, Ajax and JSON dataset. Secured by HTTPS

    The source code at GitHub
  • Java Spring Boot MVC with Spring Security

    14-September-2021

    Java Spring Boot MVC and Spring Security

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 2 minutes. A 403 Status code may happen too!

    Try the demo...

    The source code at GitHub

    Migration from Java 8 to Java 11 ! Showing and administrate a dataset of persons by a Java MVC Web Application (Secured by login) using MVC, Security, JSP, JPA, Hibernate, Maven and MS SQL


A Blog made with Gatsby React and GraphQL