How to design a model from a Self-Referencing Table

Oct 26, 2011 at 3:58 AM
Hi to everyone,
Im noob in orchard, I have the following model that can be viewed as a self-referencing table.
    public class SectionRecord : ContentPartRecord
        public virtual int SectionRecord_Id { get; set; }
        public virtual int Sequence { get; set; }
        public virtual string Title { get; set; }
        public virtual string TemplateViewName { get; set; }
        public virtual string Content { get; set; }
        public virtual string BackgroundUrl { get; set; }
        public virtual string ThumbUrl { get; set; }
        public virtual IEnumerable<SectionRecord> ChildSectionRecords { get; set; }
The problem  I encountered was during fetching(of course using NHibernate framework) of data, the ChildSectionRecords property was not loaded. The script below is what I used to fetch it.
    public class SectionService : ISectionService
        IRepository<SectionRecord> _sectionRepository;
        public SectionService(IRepository<SectionRecord> repository)
            _sectionRepository = repository;
        public IEnumerable<SectionRecord> GetSections()

            IEnumerable<SectionRecord> contents = (from section in _sectionRepository.Fetch(x=> x.Id > 0)                                                   
                                                   select section).ToList();
            return contents;

Can somebody help me how to solve this? Any help would be greatly appreciated.
Thanks in advance,