4 projects tagged with "sqlite"

• .NET 8 REST API with Dapper SQLite and xUnit
  
  11-November-2024
  

  .NET 8 REST API with C# and Dapper ORM + SQLite DB consuming an Angular 14 Client + Unit Testing

  Unit Testing:

  • xUnit - Used with one of the .NET Web API
  • Karma + Jasmine - Used with the Angular Client

  Coverage Reports are generated for visualize the result of Unit Testing ( .NET based xUnit )

  Try the demo...

  • Web API + xUnit at GitHub
  • Web API at GitHub
  • Angular Client at GitHub

  Dapper is a lightweight Micro-ORM which can be an alternative to Entity Framework Core ORM

  SQLite is local DB and fine for testing and small applications

  Traditional webhosting is used for this Application

  
  

  ---

• .NET 8 REST API Membership system + Email verification
  
  13-October-2024
  

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

  Unit Testing:

  • Karma + Jasmine - Used with the Angular Client

  Try the demo...

  • The Web API .NET 8 at GitHub
  • The Angular Client at GitHub

  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 a traditional Webhotel
  • The Angular Client is hosted at a traditional Webhotel
  • SQLite 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...

  • The Web API at GitHub
  • The Blazor Client at GitHub

  - 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 6 REST API Membership system - SQLite
  
  12-March-2024
  

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

  • The Web API at GitHub
  • The Blazor Client at GitHub

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

  SQLite is local DB and fine for testing and small applications

  Traditional webhosting is used for this Application

  
  

  ---