StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4157911
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-11-11T18:26:38.680
FavoriteCount
0
LastActivityDate
2016-01-10T20:01:22.050
LastEditDate
2016-01-10T20:01:22.050
LastEditorUserId
1688439
OwnerUserId
251305
ParentId
1875990
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
You can define an index in NHibernate using <database-object> or IAuxiliaryDatabaseObject. In a hbm.xml file: <pre><code><hibernate-mapping xmlns="urn:nhiernate-mapping-2.2"> <database-object> <create>VALID SQL</create> <drop>VALID SQL</create> </database-object> </hibernate-mapping> </code></pre> N.B. <database-object> can go before or after a class mapping in the same hbm.xml file allowing you to keep your index definitions, triggers, etc. with the object to which they apply. The other option is NHibernate.Mapping.IAuxiliaryDatabaseObject: <pre><code>namespace NHibernate.Mapping { public interface IAuxiliaryDatabaseObject : IRelationalModel { void AddDialectScope(string dialectName); bool AppliesToDialect(Dialect dialect); void SetParameterValues(IDictionary<string, string> parameters); } public interface IRelationalModel { string SqlCreateString(Dialect dialect, IMapping p, string defaultCatalog, string defaultSchema); string SqlDropString(Dialect dialect, string defaultCatalog, string defaultSchema); } } </code></pre> Given that you're using Fluent NHibernate, IAuxiliaryDatabaseObject will probably work better for you. Just expose your configuration when building it and then call: <pre><code>var sqlCreate = "CREATION SCRIPT"; var sqlDrop = "DROP SCRIPT"; cfg.AddAuxiliaryDatabaseObject(new SimpleAuxiliaryDatabaseObject(sqlCreate, sqlDrop)); </code></pre> N.B. NHibernate.Mapping.SimpleAuxiliaryDatabaseObject is part of NHibernate. You don't have to write it yourself if all you need to do is supply create/drop scripts for a database object. I took a quick look in the Fluent NHibernate codebase and didn't see any direct support for IAuxiliaryDatabaseObject. So it is a matter of exposing your configuration object and supplying all your IAuxiliaryDatabaseObjects yourself. It wouldn't be too difficult to write some code that scan through your mapping assembly looking for types that implement IAuxiliaryDatabaseObject and then foreach'ing over them to pass to cfg.AddAuxiliaryDatabaseObject(obj). You can find more information about auxiliary database objects in the NHibernate docs: <a href="http://nhibernate.info/doc/nh/en/index.html#mapping-database-object" rel="nofollow">http://nhibernate.info/doc/nh/en/index.html#mapping-database-object</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to change the column order in a multi-column index using fluent-nhibernate?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USOwen Pauling
UserOwnerUserId
1. USJames Kovacs
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to change the column order in a multi-column index using 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
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. 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.