AcroDB. Business Logic

01.cs

[AcroDbEntity]
public interface IPage
{
    Guid ID { get; set; }
    Guid? IDPageParent { get; set; }
    int Order { get; set; }
    [AcroColumnStringLength(50)]
    string Name { get; set; }
}

02.cs

public static class ExtensionIPage
{
    public static IPage GetParent(this IPage page)
    {
      return page.IDPageParent != null
               ? page.AcroContext().Provide<IPage>()
                     .Get(page.IDPageParent.Value)
               : null;
    }

    public static void SetParent(this IPage page, IPage parent)
    {
      if (parent != null)
        page.IDPageParent = parent.ID;
      else
        page.IDPageParent = null;
    }

    public static IList<IPage> GetChildren(this IPage page)
    {
      return page.AcroContext().Provide<IPage>()
                 .Query.Where(p => p.IDPageParent.Equals(page.ID))
                 .ToList();
    }
}

03.cs

using (var manager = AcroDataContext.Go)
{
  var page = manager.Provide<IPage>()
             .Query.Where(p => p.Name == "default").First();
  if (page == null)
    return;
  foreach (var p in page.GetChildren())
  {
    Console.WriteLine(p.Name);
  }
}

The article http://www.oleksiy.pro/2010/04/13/acrodb-business-logic/