StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13304625
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-09T08:36:51.683
FavoriteCount
0
LastActivityDate
2012-11-09T08:36:51.683
LastEditDate
LastEditorUserId
0
OwnerUserId
1679310
ParentId
13293026
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
<p><em>I won't anyhow discuss the correctness of this approach, just try to answer.</em> What you are trying to do: <strong>should</strong> work. I've checked the correctness of the formula in a test scenario. So, yes formula could be used exactly this way.</p> <p>But because it is not working, I would a bit guess. Let's start with SQL generated in my test case, which is working.</p> <pre><code>SELECT this_.ParentId as ParentId3_0_ , (SELECT TOP 1 Child.ChildId FROM Child WHERE Child.ParentId = this_.ParentId) as formula1_0_ FROM Parent this_ </code></pre> <h2>Possible issues</h2> <p>I see two possible issues</p> <h3>1. Different Child ID column names</h3> <p>First of all in your snippet:</p> <pre><code>References<ChildEntity>(x => x.Child).Formula( @"( SELECT TOP 1 ChildTable.ChildId FROM ChildTable WHERE ChildTable.ParentId = ParentId )" </code></pre> <p>is column name of child primary key: <strong><code>ChildId</code></strong> while in SQL snippet is the <strong><code>ChildEntity_id</code></strong>:</p> <pre><code>SELECT this_.ParentId, this_.ChildEntity_id FROM ParentTable this_ </code></pre> <h3>2. SQL Snippet does not match</h3> <p>Secondly, you mentioned that the (SQL Statement just above) is what was generated. But it is more like a statement of this mapping:</p> <pre><code>References<ChildEntity>(x => x.Child).Column("ChildEntity_id") </code></pre> <p>So couldn't be there some older/other mapping, which is in fact used?</p> <p>SUMMARY I wanted to say, that this way of mapping is working. So you are on the correct track, but <em>the devil is hidden in details</em> ;)</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POReference an entity with a formula in Fluent NHibernate
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRadim Köhler
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POReference an entity with a formula in Fluent NHibernate
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.