public static OrderScheduleViewModel GetOrderSchedulebyId(int? id) { var db = new IstokDoorsDBContext(); var myOrderSchedule = db.usp_GetOrderScheduleById(id).Single(); //TODO: Don't forget to add Single method to materialize the object!!! var myOrderScheduleViewModel = new OrderScheduleViewModel(); myOrderScheduleViewModel.OrderId = myOrderSchedule.OrderId; myOrderScheduleViewModel.FactoryName = myOrderSchedule.FactoryName; myOrderScheduleViewModel.FactoryId = myOrderSchedule.FactoryId??1; myOrderScheduleViewModel.DateOfCreation = myOrderSchedule.DateOfCreation; myOrderScheduleViewModel.DateEntryToFactory = myOrderSchedule.DateEntryToFactory; myOrderScheduleViewModel.PlannedDateOfManufacture = myOrderSchedule.PlannedDateOfManufactoring; myOrderScheduleViewModel.PlannedDateOfShipping = myOrderSchedule.PlannedDateOfShipping; myOrderScheduleViewModel.ActualDateOfManufacture = myOrderSchedule.ActualDateOfManufactoring; myOrderScheduleViewModel.ActualDateOfShipping = myOrderSchedule.ActualDateOfShipping; return myOrderScheduleViewModel; }