StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFluent NHibernate mapping to return description from lookup table
primarykey
Id
16013792
data
AcceptedAnswerId
16014818
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-15T11:16:04.490
FavoriteCount
0
LastActivityDate
2013-04-15T12:10:31.707
LastEditDate
LastEditorUserId
0
OwnerUserId
448129
ParentId
0
PostTypeId
1
Score
0
ViewCount
565
LastEditorDisplayName
text
Body
We have the following database structure: <pre><code>UserTeam table Id (PK, int not null) UserId (FK, int, not null) TeamId (FK, int, not null) RoleId (FK, int, not null) libRole table Id (PK, int not null) Description (varchar(255), not null) </code></pre> And we have an entity as follows: <pre><code>public class UserTeam { public int Id { get; set; } public Team Team { get; set; } public User User { get; set; } public int RoleId { get; set; } public string Role { get; set; } } </code></pre> We are using Fluent NHibernate and configuring NHibernate automatically (ie, using Automapping classes with overrides). We are trying to get JUST the description column from the libRole table into the "Role" property on the UserTeam table, but really struggling. The following is the closest we have got: <pre><code>public class UserTeamMap : IAutoMappingOverride<UserTeam> { public void Override( FluentNHibernate.Automapping.AutoMapping<UserTeam> mapping ) { mapping.References( m => m.User ).Column( "UserId" ); mapping.References( m => m.Team ).Column( "TeamId" ); mapping.Join("Role", join => { join.Fetch.Join(); join.KeyColumn( "Id" ); join.Map( x => x.Role, "Description" ); } ); } } </code></pre> Which generates the following SQL: <pre><code>SELECT TOP (@p0) this_.Id as Id70_0_, this_.RoleId as RoleId70_0_, this_.TeamId as TeamId70_0_, this_.UserId as UserId70_0_, this_1_.Description as Descript2_71_0_ FROM [UserTeam] this_ inner join libRole this_1_ on this_.Id=this_1_.Id; </code></pre> Close, but NHibernate is using the Id column on both the UserTeam table and the libRole table in the join, when it should be doing on <code>this_.RoleId=this_1_.Id</code> What are we missing? We don't really want to create a "libRole" entity within the application, as all we really care about is the description values - which are user configurable, so we can't just use an enum either. Can anyone help?
Tags
<nhibernate><fluent-nhibernate><fluent-nhibernate-mapping>
Title
Fluent NHibernate mapping to return description from lookup table
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMajorRefactoring
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
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.