VELODemo

A Blazor Server application built on the Northwind starter template, using ASP.NET Core (.NET 10) and Entity Framework Core. It includes customer, employee, order, product, and reporting features, and seeds its data automatically from CSV files on startup.

---

Prerequisites

Requirement	Version
Visual Studio	2022 v17.x or later
.NET SDK	10.0 or later
(Optional) SQL Server	Any edition — only needed if you want a persistent database

Note: The app works out of the box with an In-Memory database. No SQL Server installation is required for a quick run.

---

Steps to Run in Visual Studio

1. Open the solution

1. Launch Visual Studio 2022.
2. Select File → Open → Project/Solution.
3. Browse to the cloned/downloaded folder and open VELODemo.sln.

2. Restore NuGet packages

Visual Studio restores packages automatically when the solution loads. If it does not, right-click the solution in Solution Explorer and choose Restore NuGet Packages.

3. (Optional) Configure a SQL Server database

By default the app uses an In-Memory database that is seeded from the CSV files in Data/. If you prefer a persistent SQL Server database:

1. Open Generated_northwindstarteredit-.../appsettings.json.
2. Fill in the DefaultConnection string:

"ConnectionStrings": {
  "DefaultConnection": "Server=YOUR_SERVER;Database=NorthwindDemo;Trusted_Connection=True;TrustServerCertificate=True;"
}

3. Open the Package Manager Console (Tools → NuGet Package Manager → Package Manager Console) and run:

Update-Database

4. Set the startup project

In Solution Explorer, right-click the project Generated_northwindstarteredit-... and select Set as Startup Project.

5. Run the application

Press F5 (Debug) or Ctrl+F5 (Run without debugging).

Visual Studio will build the project, start the Kestrel server, and open a browser automatically.

Profile	URL
HTTP	http://localhost:5267
HTTPS	https://localhost:7193

6. First run — data seeding

On the first startup the application automatically seeds all tables from the CSV files located in the Data/ folder. No manual database setup is needed when using the In-Memory provider.

---

Project Structure

VELODemo.sln
└── Generated_northwindstarteredit-.../
    ├── Components/        # Blazor pages, layouts, and forms
    ├── Data/              # CSV seed files
    ├── Models/            # EF Core entity models
    ├── Services/          # Business logic and data-access services
    ├── Helpers/           # App-wide constants
    ├── wwwroot/           # Static assets
    ├── appsettings.json   # App configuration (connection string goes here)
    └── Program.cs         # Application entry point and DI registration

---

Troubleshooting

• Build errors after pulling updates — Run Build → Clean Solution, then Build → Rebuild Solution.
• Port already in use — Change the port in Properties/launchSettings.json under applicationUrl.
• Data not showing — Ensure the CSV files in Data/ are set to Copy to Output Directory: Always (they are by default in the .csproj).