public class SosResearchFile
    {
        public virtual string Id { get; set; }  
        public virtual int TypeId { get; set; }
        public virtual string ResearchId { get; set; }

        public virtual byte[] FileData { get; set; }
        public virtual string FileName { get; set; }
        public virtual string Description { get; set; }
         
        public virtual byte[] GetDecodedFile()
        {
            byte[] file;
            TsosGdisDecoder.Decode(FileData, out file);
            return file;
        }        
    }

    class SosResearchFileMap:ClassMap<SosResearchFile>
    {
        public SosResearchFileMap()
        {
            ReadOnly();
            Table("SOSRESEARCHFILE");
            Id(x => x.Id, "RFID");
            Map(x => x.TypeId, "RFTYPEID");
            Map(x => x.ResearchId, "RFRESEARCHID");
            Map(x => x.FileData, "RFFILEDATA");//.LazyLoad();
            Map(x => x.FileName, "RFFILENAME");
            Map(x => x.Description, "RFDESCRIPTION");
        }
    }

-------------------------------------------
SOSRESEARCHFILE
-------------------------------------------
RFID VARCHAR2(22) - PK
RFTYPEID NUMBER(9)
RFFILEDATA BLOB - Nullable
RFRESEARCHID VARCHAR2(22) - FK на RESID таблицы SOSRESEARCH
RFFILENAME VARCHAR2(240) - Nullable
RFDESCRIPTION VARCHAR2(120) - Nullable
------------------------------------------

-------------------------------------------
SOSRESEARCHGRAPH
-------------------------------------------
RGRID VARCHAR2(22) - PK
RGRRESEARCHID VARCHAR2(22) - FK на RESID таблицы SOSRESEARCH
RGRPICTURE BLOB	 - Nullable
RGRDESCRIPTION VARCHAR2(120) - Nullable
RGRTYPE NUMBER(9)
RGRSRC NUMBER(9)
RGRINDEX NUMBER(9) - Nullable
RGRMAIN NUMBER(1) - Nullable
RGRMETAFILE BLOB - Nullable
------------------------------------------

------------------------------------------------
SOSRESEARCH
------------------------------------------------
RESID VARCHAR2(22) - PK
... набор остальных полей таблицы
----------------------------------------------

        public IList<SosResearchGraph> GetResearchGraphs(string researchId)
        {
            var criteria = _session.Instance.CreateCriteria(typeof(SosResearchGraph));
                criteria.Add(Restrictions.Eq("ResearchId", researchId));
            var pictures = criteria.List<SosResearchGraph>();
            return pictures;
        }	

        public IList<SosResearchFile> GetResearchFiles(string researchId)
        {
            var criteria = _session.Instance.CreateCriteria(typeof(SosResearchFile));
            criteria.Add(Restrictions.Eq("ResearchId", researchId));
            var files = criteria.List<SosResearchFile>();
            return files;
        }