gistfile1.cs

				return context.eumarketing_milestonemetadatas.Select( md =>
					new MilestoneHierarchy() {
						ProjectID = md.ProjectID
						,
						MilestoneID = md.MilestoneID
						,
						MilestoneName = md.eumarketing_milestone.MilestoneName
						,
						ProjectName = md.eumarketing_project.ProjectName
						,
						ProjectLabelId = md.eumarketing_project.LabelId.Value
						,
						MilestoneGroupId = md.eumarketing_milestone.GroupId.Value
						,
						MilestoneGroupName = md.eumarketing_milestone.eumarketing_milestoneGroup.GroupName
						,
						ProjectLabelName = md.eumarketing_project.eumarketing_label.Name
						,
						PlanEndDate = md.PlanEndDate.Value
						,
						ActualEndDate = md.ActualEndDate.Value
						,
						EndPlanEndDate = md.EndPlanEndDate.Value
						,
						EndActualEndDate = md.EndActualEndDate.Value
						,
						PercentComplete = md.PercentComplete.Value
						,
						Status = ( Milestone.MilestoneStatus )md.Status.Value
						,
						Comment = md.StatusNotes
						,
						IsActive = Convert.ToBoolean( md.IsActive.Value )
						,
						DateSubmitted = md.DateSubmitted.Value
						,
						Submitter = md.Submitter.HasValue ? md.Submitter.Value : 0
						,
						NeedsApproval = md.NeedsApproval
					}
				).Where( md => md.IsActive && !md.Removed )
				.Where( filter )
				.ToList();