public static List <DivisionList> getDivisionForBU(string BU) { using (var context = new SalesReturndbEntities()) { var list = context.SP_Get_Division_For_BU(BU).ToList(); List <DivisionList> DivisionList = null; if (list != null) { DivisionList = list.Select(x => new DivisionList() { DivisionName = x.Dept_name }).ToList(); return(DivisionList); } return(DivisionList); } }