public static ProductCollection GetAllProductsIncludingDeactivated() { ProductCollection departmentProducts = new ProductCollection(); List <GetAllProductsIncludingDeactivatedDistinct_Result> result = new List <GetAllProductsIncludingDeactivatedDistinct_Result>(); using (FreeMarketEntities db = new FreeMarketEntities()) { result = db.GetAllProductsIncludingDeactivatedDistinct() .ToList(); departmentProducts = SetProductIncludingDeactivatedDataDistinct(result); return(departmentProducts); } }