public Int32 GetPatologiasId(string nom_pat) { int id = 0; var query = from diag in entities.diagnosticos where nom_pat == diag.diagnostico1 select diag.id; id = Convert.ToInt32(query.FirstOrDefault()); return id; }