Install SQL Developer IDE:

Download link -> https://www.oracle.com/br/database/sqldeveloper/technologies/download/

Recommended version: Oracle IDE 23.1.1.345.2114 or higher

It's recommended to install the version with JDK included: Windows 64-bit with JDK 17 included

During installation, make sure to create the user as SYSTEM and save the password you set. You'll need it for the next steps.

Step 1: Clone or Download the Project

Create a directory on your machine to store the project and use it in Visual Studio 2022.

Clone the repository:

git clone git@github.com:troy-miller0824/aspnet-core-angular-oracle-fullstack-api.git

Step 2: Open SQL Developer and connect using the SYSTEM user

Step 3: Create the Tablespace

create tablespace crudecmaxima
 datafile
   'C:\oraclexe\app\oracle\oradata\XE\crudecmaxima.dbf' 
   size 100m autoextend on next 50m maxsize 500m
   online
   permanent
   extent management local autoallocate
   segment space management auto;

Step 4: Open the Project in Visual Studio 2022

You should see the following structure:

.
├── Config/                 
├── Controllers/            
├── DataBaseSetup/          
├── Models/                 
├── Pages/                  
├── Properties/             
├── wwwroot/                
├── appsettings.json        
└── Program.cs              

If not, double-click DotNetApiMaxima.sln

Step 5: Create Database Objects

In Visual Studio 2022, navigate to:

├── DataBaseSetup/
│   └── create_pkg.sql

Inside the file, you'll find detailed instructions to execute the database setup package.

Step 6: Seed Initial Data

-- Departments
INSERT INTO MXSDEPARTAMENTO ...

-- Products
INSERT INTO MXSPRODUTO ...

-- Users
INSERT INTO MXSUSUARIOS ...

Step 7: Install Node.js

Install Node.js v18.20.5 (Angular does not support version 23)

Download link -> https://nodejs.org/pt

Follow the standard installation process (Next → Next → Finish).

Step 8: Backend Setup Notes

Verify that the following packages are installed in Visual Studio 2022:

• Oracle.EntityFrameworkCore 9.23.60
• Swashbuckle.AspNetCore.Swagger 7.2.0
• Swashbuckle.AspNetCore.SwaggerGen 7.2.0
• Swashbuckle.AspNetCore.SwaggerUI 7.2.0
• Microsoft.EntityFrameworkC 9.0.0
• Microsoft.AspNetCore.Authentication.JwtBearer 8.0.0

Step 9: Frontend Dependencies

These dependencies are installed during Angular and project setup:

├── @angular-devkit/build-angular@12.2.18
├── @angular/core@12.2.17
├── rxjs@6.6.3
├── typescript@4.3.5
└── zone.js@0.11.8

Step 10: Install Angular CLI

Make sure Node.js and npm are installed.

npm install -g @angular/cli@12

Inside the project:

cd Frontend
npm install

Check installation:

ng version

Step 11: Run the Backend

In Visual Studio 2022 terminal:

cd .\DotNetApiMaxima
dotnet run

Step 12 (Final): Run the Frontend

cd Frontend
npm start

How to Contribute

If you'd like to contribute, follow these steps:

1. Fork the repository
2. Create a new branch (git checkout -b my-feature)
3. Make your changes and commit (git commit -am 'Add new feature')
4. Push to your branch (git push origin my-feature)
5. Open a Pull Request

Best practices:

• Add automated tests when introducing new features
• Keep your code well documented
• Follow the existing code style and formatting