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 PRN231PE_SP24_123890_StudentCode.
2. Create your MS SQL database named Watercolors Painting2024DB by running code in script Watercolors Painting2024DB.sql.
3. Set the default Client application for your project as Login page
4. 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. 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 0 mark.
5. The database connection string must get from the appsettings.json file.
6. Note: Please check before you submit your work, no syntax error(s) in the submitted PE. If there are syntax errors or compilation errors in your PE program, you will not pass the PE requirements, the mark will be 0.
Implement a part of Watercolors Painting Application. The below Figure is Watercolors Painting2024DB database.a part of
Zoom
Close
UserAccount
Stvle
Watercolors Painting
100%
