public static DateTime?GetDateMaxForDossierFromSP(string dossier, DateTime dateArret) { try { using (var context = new CompteResultatEntities()) { var res = context.SPGetDateMaxForDossier(dossier, dateArret).FirstOrDefault(); if (res.HasValue) { return(res.Value); } else { return(null); } } } catch (Exception ex) { log.Error("Error :: GetDateMaxForDossierFromSP : " + ex.Message); throw ex; } }