StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Perhaps this is a recent fix in FluentNHibernate, but this works with FluentNH v1.2.0.712. I'm fairly confident that NHibernate with plain *.hbm.xml mappings has supported this type of mapping for years.</p> <p>This is the automapping override that worked for me:</p> <pre><code>mapping.HasMany(x => x.SupportedTransactionTypes) .Element("TransactionTypeId"); </code></pre> <p>...which results in this XML...</p> <pre><code><hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <class xmlns="urn:nhibernate-mapping-2.2" name="so.Q2676867.PaymentMethod, so, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" table="`PaymentMethod`"> <id access="backfield" name="Id" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <column name="Id" /> <generator class="identity" /> </id> <bag name="SupportedTransactionTypes"> <key> <column name="PaymentMethod_id" /> </key> <element type="so.Q2676867.TransactionType, so, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"> <column name="TransactionTypeId" /> </element> </bag> </class> </hibernate-mapping> </code></pre> <p>... and these tables:</p> <pre><code>create table [PaymentMethod] ( Id INT IDENTITY NOT NULL, primary key (Id) ) create table SupportedTransactionTypes ( PaymentMethod_id INT not null, TransactionTypeId INT null ) alter table SupportedTransactionTypes add constraint FK738E3751B597A1C foreign key (PaymentMethod_id) references [PaymentMethod] </code></pre> <p>... which is exactly what I would expect. Yay NHibernate!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload