Test #1

PURPOSE

The purpose of this test is to test your MVC.NET, JavaScript, and your LINQ-to-SQL skill. This is NOT to assess your design skill. Please create a very simple UI.

Prerequisite

• Visual Studio 2017 Community (https://visualstudio.microsoft.com/vs/older-downloads/).
• SQL Express (https://www.microsoft.com/en-us/sql-server/sql-server-downloads)
• SQL Management Studio (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

INSTRUCTIONS

• Download the following zip file containing the SQL scripts to create DB, tables and to insert dummy data.
• Using SQL Management Studio, open and run XcifySampleTestDB_CreateDB.sql and XcifySampleTestDB.sql in sequence.
• Open Visual Studio and create a new MVC.NET project
• Create a simple form with only 1 button and label it "Display All Products".
• Using AJAX, retrieve all product records from tblProduct and display field "Name" and "Price" in a simple table.
• In this exercise, you must use LINQ to SQL to retrieve data from SQL Express database
• Once you have completed and tested, zip the entire solution/project file
• Please use external storage (eg. wetransfer, google drive, dropbox, onedrive) to send the file to us

NOTE:
If you do not have a computer or enough storage on your computer to install the prerequisite software mentioned above, please send us an email. We can arrange for you to come onsite to complete the test.

---