public lkup_faclty GetFacilityByOrganization(decimal id) { try { using ( var ctx = new ClinicDataContext(connString) ) { return ctx.lkup_faclty.Where(v => v.orgzn_id == id).FirstOrDefault(); } } catch ( Exception ex ) { throw ex; } }