public static List <CDemoData> GetDemoDataFromSP(string assurList, string parentCompanyList, string companyList, string contractList, DateTime debutPeriode, DateTime finPeriode) { try { List <CDemoData> demoData; using (var context = new CompteResultatEntities()) { //### do we also need to select demo data by codecol //companyList: "ACTI ALT2,ACTI ALT" => no space can be before or after the , demoData = context.SPGetDemoData(assurList, parentCompanyList, companyList, contractList, debutPeriode, finPeriode).ToList(); } return(demoData); } catch (Exception ex) { log.Error(ex.Message); throw ex; } }