BuildTrack

C# + .NET MVC application using the Entity Framework Core for scaffolding and PostgreSQL as the backend database.

GitHub: BuildTrack

---

First Steps

Before running the project, make sure you have .NET installed.

• Mac: Install via Homebrew:

brew install dotnet

• Or use Visual Studio Community.
• The project was developed using VS Code, but any IDE supporting .NET works.

You also need the Entity Framework CLI:

dotnet tool install --global dotnet-ef

---

Installing (Using PostgreSQL)

1. Open your terminal and create the database using psql:

psql -U postgres -c "CREATE DATABASE buildtrackmvc";

Replace postgres with your PostgreSQL username if different.

Bonus Command: psql -U postgres -l to list current databases.

2. Restore project dependencies:

dotnet restore

3. Create and apply EF Core migrations:

dotnet ef migrations add InitialCreate

• Then apply migrations to the database:

dotnet ef database update

4. (Extra - Not necessary) Build the project:

dotnet build

---

Configuration

The connection string is set in appsettings.json:

"ConnectionStrings": {
  "DefaultConnection": "Host=localhost;Port=5432;Database=buildtrackmvc;Username=postgres;Password=7603;Include Error Detail=true"
}

Update Username and Password according to your local PostgreSQL credentials.

---

Running

Run the application using:

dotnet watch run

The app should now be accessible at https://localhost:5015 (or the port indicated in the console).

---

Sources & References

• AdminLTE v4
• YouTube Tutorial

---

Author

• t2ne