public OPDInvestigationCollection(Guid OPDInvestigationGuid)
 {
     using (SqlDataReader dr = AppDAL.OPDInvestigationSelect(OPDInvestigationGuid))
     {
         LoadObjectsFromReader(dr);
     }
 }
        protected override bool OpenRecord(Guid key)
        {
            bool r = false;

            using (SqlDataReader dr = AppDAL.OPDInvestigationSelect(key))
                r = dr != null && dr.Read() && this.Populate(dr);
            return(r);
        }