public DesignerDrogAttachment DesignerDrogAttachmentSelectFile( DBGuid IDVal )
        {
            TraceCallEnterEvent.Raise();
            try
            {
            DesignerDrogAttachment result = base.DesignerDrogAttachmentSelect( IDVal );
            if (result != null && !result.Path.IsNull)
            {
                FileDataContext fileDataContext = new FileDataContext();
                string ext = Path.GetExtension( result.Path ).ToLower();
                string fileName = result.ID.ToString() + ext;
                result.FileData = fileDataContext.DesignerDrogAttachmentSelect( result.ItemRef, fileName );
            }

            TraceCallReturnEvent.Raise();
            return result;
            }
            catch (Exception ex)
            {
            ExceptionManager.Publish( ex );
            TraceCallReturnEvent.Raise( false );
            throw;
            }
        }