Anton
Anton

Reputation: 4584

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?

Upvotes: 1

Views: 223

Answers (1)

user1151
user1151

Reputation:

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.

Upvotes: 1

Related Questions