crtsms/challenge

Code Challenge

Challenge app

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

Live demo

• See the live demo - Hosted on Microsoft Azure

Getting Started

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