This app is really simple, have 3 tables, Employee, Skill and EmployeeSkill. Althought it's simple, have some interesting stuff, like:
- Remote validation of properties of model
- Async action methods
- Modal to edit ternal relationship
- Load multiple partial view, in same page, with asynchronous operations
- Use Model, ModelView, View and Controller
- Use POCO Entities
- See the live demo - Hosted on Microsoft Azure
Restore NuGet packages with the following command
nuget restore Challenge.sln
Restore database running SQLServer on Linux Container
sudo docker exec -it mssql /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P 'Pa$$w0rd' \
-Q 'RESTORE DATABASE EmployeeSkills FROM DISK = "/var/opt/mssql/backup/EmployeeSkills.bak" WITH FILE = 1,
MOVE "EmployeeSkills" TO "/var/opt/mssql/data/EmployeeSkills.MDF",
MOVE "EmployeeSkills_LOG" TO "/var/opt/mssql/data/EmployeeSkills_LOG.LDF"'
Restore database running SQLServer Express 2014 on Windows 7
sqlcmd -S crisleiOldMachine\SQLExpress
RESTORE DATABASE EmployeeSkills
FROM DISK = N'C:\EmployeeSkills.bak'
WITH FILE = 1,
MOVE N'EmployeeSkills' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\EmployeeSkills.MDF',
MOVE N'EmployeeSkills_LOG' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\EmployeeSkills_LOG.LDF',
NOUNLOAD,
REPLACE,
STATS = 10
GO