.NET web api backend for Dashboard starter

Features

• Built on .NET 7.0, Oracle 19c and MS SQL Server 2022
• Follows Clean Architecture Principles
• Repository Pattern with Dapper
• Integration with Swagger, Serilog, AutoMapper, Newton Json(Json.NET), Dapper
• Unit tests with xUnit and Moq

Getting Started

To create schema and seed data in Oracle 19c and above:

• You may run the SQL scripts in the database\oracle-19c folder, as privileged user with rights to create another user (SYSTEM, ADMIN, etc.)
  dashboard_schema_create.sql
  dashboard_create.sql
  dashboard_populate.sql
• Or you may import the dashboard.dmp file in the database folder with the below command:

impdp userid=username/password@//server-ip:1521/service-name DIRECTORY=orcl_dump   DUMPFILE=dashboard.dmp FULL=Y

To remove the schema

• You may run the SQL dashboard_schema_drop.sql in the database folder.
• Or you may drop the schema with the below command:

DROP USER DASHBOARD CASCADE

Design