How azure-samples/app-templates-dotnet-azuresql-appservice works
Contoso University is a Razor Pages frontend backed by a separate ASP.NET Core API and Entity Framework Core data layer. Users manage students, courses, departments, and instructors: the web pages issue HTTP requests to the API, whose controllers query or update the SQL-backed context and return DTO-shaped results. API startup also initializes sample data. The README documents Azure hosting, Azure SQL, and Application Insights; the available source excerpts do not show frontend client configuration or telemetry wiring, so those connections are not asserted here.
Main entry points: Program.cs API host · ContosoUniversityAPIContext.cs EF Core context · CoursesController.cs Courses API · DepartmentsController.cs Departments API
Components 20
Web frontend
- Razor Pages app
src/ContosoUniversity.WebApplication/Program.cs - Course pages
src/ContosoUniversity.WebApplication/Pages/Courses - Department pages
src/ContosoUniversity.WebApplication/Pages/Departments - Instructor pages
src/ContosoUniversity.WebApplication/Pages/Instructors - Student pages
src/ContosoUniversity.WebApplication/Pages/Students - API view models
src/ContosoUniversity.WebApplication/Models/APIViewModels - Pagination helper
src/ContosoUniversity.WebApplication/PaginatedList.cs
University API
- API host
src/ContosoUniversity.API/Program.cs - Courses API
src/ContosoUniversity.API/Controllers/CoursesController.cs - Departments API
src/ContosoUniversity.API/Controllers/DepartmentsController.cs - Instructors API
src/ContosoUniversity.API/Controllers/InstructorsController.cs - Students API
src/ContosoUniversity.API/Controllers/StudentsController.cs - API result DTOs
src/ContosoUniversity.API/DTO - Application Insights
Persistence and domain
- EF Core context
src/ContosoUniversity.API/Data/ContosoUniversityAPIContext.cs - Sample data initializer
src/ContosoUniversity.API/Data/DbInitializer.cs - University entities
src/ContosoUniversity.API/Models - Azure SQL database
- Azure Key Vault
Other components
- University user
Connections 25
- University user → Razor Pages app: uses
README.md - Course pages → Courses API: HTTP requests
- Department pages → Departments API: HTTP requests
- Instructor pages → Instructors API: HTTP requests
- Student pages → Students API: HTTP requests
- Course pages → API view models: deserializes to
src/ContosoUniversity.WebApplication/Pages/Courses/Edit.cshtml.cs - Razor Pages app → Course pages: hosts
- API host → Courses API: routes
- API host → Departments API: routes
- API host → Instructors API: routes
- API host → Students API: routes
- Courses API → EF Core context: queries and updates
src/ContosoUniversity.API/Controllers/CoursesController.cs - Departments API → EF Core context: queries and updates
src/ContosoUniversity.API/Controllers/DepartmentsController.cs - Instructors API → EF Core context: queries and updates
src/ContosoUniversity.API/Controllers/InstructorsController.cs - Students API → EF Core context: queries and updates
src/ContosoUniversity.API/Controllers/StudentsController.cs - Courses API → API result DTOs: maps results
src/ContosoUniversity.API/Controllers/CoursesController.cs - Departments API → API result DTOs: maps results
src/ContosoUniversity.API/Controllers/DepartmentsController.cs - Students API → API result DTOs: maps results
src/ContosoUniversity.API/Controllers/StudentsController.cs - EF Core context → University entities: maps entities
src/ContosoUniversity.API/Data/ContosoUniversityAPIContext.cs - API host → EF Core context: registers and resolves
src/ContosoUniversity.API/Program.cs - API host → Sample data initializer: runs at startup
src/ContosoUniversity.API/Program.cs - Sample data initializer → EF Core context: seeds
src/ContosoUniversity.API/Data/DbInitializer.cs - EF Core context → Azure SQL database: persists via EF Core
- API host → Azure Key Vault: loads secrets from
src/ContosoUniversity.API/Program.cs - API host → Application Insights: configures telemetry
src/ContosoUniversity.API/Program.cs