PE_PRN231_SU24_009909 SUMMER 2024
Subject: PRN231
Duration: 90 minutes
INSTRUCTIONS
Please read the instructions carefully before doing the questions.
You are NOT allowed to use any device to share data with others.
You must use Visual Studio 2019 or above, MSSQL Server 2012 or above for your development tools.
IMPORTANT - before you start doing your solution, MUST do the following steps:
1. Create Solution/Project in Visual Studio named PEPRN231_SU24_009909_StudentFullname_BE for
API, and PEPRN231_SU24_009909_StudentCode_FE for Client Application. Set the default Client application for your project as Login page.
2. Create your MS SQL database named English PremierLeague2024DB by running code in script English Premier League2024DB.sql.
3. You are not allowed to connect directly to a database from ASP.NET Core Web API, every database connection must be used with Repository and Data Access Objects.
4. The database connection string must get from the appsettings.json file. In the case your code connects direct to the database from ASP.NET Core Web API or hard coded the connection string, you will get
Close
+ 100%
Zoom
