StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4099951
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-11-04T18:28:49.313
FavoriteCount
0
LastActivityDate
2016-08-11T05:21:24.970
LastEditDate
2016-08-11T05:21:24.970
LastEditorUserId
919426
OwnerUserId
185738
ParentId
4099617
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Not quite sure what do you mean by Aggregate Root. As far as I know the Repository Pattern usually works with a cluster of objects that are part of your domain model, in DDD this usually refers as <a href="https://web.archive.org/web/20110503184234/http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/10/08/the-repository-pattern.aspx" rel="nofollow">aggregates</a>. How do you access you objects from a repository depends on what kind of data access layer you use in you application. I usually use NHibernate as and ORM that manages all the relationships between my classes and database tables, so when I implement a repository I can use any objects that are a part of my domain and access them as needed.</p> <p>Here is an example of a repository that uses different objects:</p> <pre><code>public interface IStoryRepository : IRepository<Story> { List<Image> GetStoryImage(int id); List<FacebookUser> GetFbUserById(string id); } public class StoryRepository : Repository<Story>, IStoryRepository { public List<Image> GetStoryImage(int id) { var criteria = Session.CreateCriteria(typeof(Image)) .Add(Restrictions.Eq("Id", id)) .SetResultTransformer(new DistinctRootEntityResultTransformer()); return criteria.List<Image>() as List<Image>; } public List<FacebookUser> GetFbUserById(string id) { var criteria = Session.CreateCriteria(typeof(FacebookUser)) .Add(Restrictions.Eq("Id", id)) .SetResultTransformer(new DistinctRootEntityResultTransformer()); return criteria.List<FacebookUser>() as List<FacebookUser>; } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODDD - Building Repositories
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USuser919426
UserOwnerUserId
1. USVasile Laur
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThat cluster of objects is what is referred to as the aggregate, the aggregate root is the top-level object that you would ask the repository to provide, it has global identity.
  singulars
  PostPostId
  PO
  UserUserId
  USDavid
2. COIn my case If I needed to use eager loading I would use: .SetFetchMode("Story", FetchMode.Eager)
  singulars
  PostPostId
  PO
  UserUserId
  USVasile Laur

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.