I want to order the period start date first for each employee. So 12/5/2015 should go before 12/12/2015. I want to do this using LINQ
TABLE TEMP
empno project task hrs periodStart periodEnd
BBBB red REG 40 12/12/2015 12/18/2015
BBBB red PTO 40 12/5/2015 12/11/2015
CCCC blue REG 40 12/5/2015 12/11/2015
CCCC blue REG 40 12/12/2015 12/18/2015
DDDD white PTO 40 12/12/2015 12/18/2015
DDDD white REG 40 12/5/2015 12/11/2015