Search code examples
subsonicsubsonic3foreign-keyssimplerepository

SubSonic SimpleRepository - Foreign Objects

SubSonic SimpleRepository doesn't seem to have a lot of support for foreign relations. How can I have foreign relationships in my code models that persist and load from the database naturally?

Solution

  • FKs are a DB concern - the Simple Repo is there to work as simply as possible so if you have a collection of child objects, you load them as needed:

    public IEnumerable Kids{ get{ return Kids.All().Where(x=>x.ParentID==this.ID;
    } }

    You'd have to roll this by hand. If you want to "eager" load it - do on a case by case basis.