6 projects tagged with "sqlite"
- .NET 8 and Umbraco CMS Website - Basic Starter
24-May-2025A Website by Umbraco CMS 13 and .NET 8 using SQLite DB for both Dev + Prod serving as a Basic Starter
Try the demo...This Website was created by Umbraco CMS 13 and .NET and hosted at a tradiotional Web Hotel using IIS
The source code at GitHub - .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 )
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
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 8 REST API doing Authentication by JWT and Refresh Tokens
05-May-2024Angular client towards a REST API by .NET 8 with C# using JWT and Refresh Tokens for Authentication
Traditional webhosting is used for this Application
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
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
By using JWT + Refresh Tokens the security will be improved. The JWT can have a reduced time to live and therefor less likely to be stolen
- .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
- C#
- Registration of Users
- JWT authentication
- CRUD Account managementMS 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
- C#
- Registration of Users
- JWT authentication
- CRUD Account managementSQLite is local DB and fine for testing and small applications
Traditional webhosting is used for this Application