public static List <CCStackHolder> GetCCStackHolderDetail() { using (var context = new SalesReturndbEntities()) { var dataList = context.spGetCCStackHolderDetail().Where(x => x.IsDeleted == false).ToList(); List <CCStackHolder> objList = new List <CCStackHolder>(); if (dataList != null) { objList = dataList.Select(x => new CCStackHolder() { Catalyst = x.Catalyst, ComplaintHandler = x.ComplaintHandler, ComplaintManager = x.ComplaintManager, CreatedBy = x.CreatedBy, IsDeleted = x.IsDeleted, ComplaintStakeHolders_ID = x.ComplaintStakeHolders_ID, CreationDate = x.CreationDate, LocalTechnical = x.LocalTechnical, Manager = x.Manager, SBU_Name = x.SBU_Name, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).ToList(); return(objList); } return(objList); } }