public static Vendor GetVendor(int id) { Vendor vendor; using (CustomClearviewEntities ctx = new CustomClearviewEntities()) { VendorRepository repo = new VendorRepository(ctx); vendor = repo.Find(x => x.VendorId == id, type => type.Offices, type => type.SalesChannel); } return(vendor); }