nhibernate - w3toppers.com

Generate XML mappings from fluent Nhibernate

You can do something like: config.Mappings(m => { m.FluentMappings.ExportTo(“…file path here…”); m.HbmMappings.ExportTo(“…file path here…”); m.AutoMappings.ExportTo(“…file path here…”); { ); I don’t like it myself. If I find some better way (if such exists at all) I’ll update the answer. See http://blog.jagregory.com/2009/02/03/fluent-nhibernate-configuring-your-application/ Or if broken, see this instead https://github.com/jagregory/fluent-nhibernate/wiki/Database-configuration

NHibernate configuration for uni-directional one-to-many relation

NH3 and above allow to correct save entities in case of uni-directional one-to-many mapping without annoying save null–save–update cycle, if you set both not-null=”true” on <key> and inverse=”false” on <one-to-many> FluentNHibernate code snippet for that: public class MasterMap : ClassMap<Master> { public MasterMap() { Id(x => x.MasterId); Map(x => x.Name); HasMany(x => x.Details) .Not.Inverse() //these … Read more

How to save a child with assigned id in nhibernate

When cascading from a parent to a child, NHibernate uses the SaveOrUpdate method. You are correct that NHibernate need some way to determine whether it should perform an insert or an update. It will look at three different fields for an unsaved value to determine if the entity is new. Id Version Timestamp With an … Read more

Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)

I too have encountered a similar problem and after much experimentation I noticed that when using Nhibernate to generate my schema to a file the generated column type was always length 8000. Setting setting CustomSqlType to Varbinary(max) as suggested above made no difference, however, this work around in my FluentMapping seemed to do the trick: … Read more

How to create OR statements for NHibernate?

You’re looking for the Conjunction and Disjunction classes, these can be used to combine various statements to form OR and AND statements. AND .Add( Expression.Conjunction() .Add(criteria) .Add(other_criteria) ) OR .Add( Expression.Disjunction() .Add(criteria) .Add(other_criteria) )

NHibernate – CreateCriteria vs CreateAlias

given these requirements there would be no difference, the generated SQL is the same: for mappings: <?xml version=”1.0″ encoding=”utf-8″ ?> <hibernate-mapping xmlns=”urn:nhibernate-mapping-2.2″> <class name=”Project” table=”Project”> <id name=”Id” type=”Int32″ unsaved-value=”0″> <column name=”Id” sql-type=”int” not-null=”true” unique=”true”/> <generator class=”native” /> </id> <many-to-one name=”Job” column=”FK_JobId” cascade=”save-update” not-null=”true” /> </class> </hibernate-mapping> <?xml version=”1.0″ encoding=”utf-8″ ?> <hibernate-mapping xmlns=”urn:nhibernate-mapping-2.2″> <class name=”Job” table=”Job”> … Read more

Fluent NHibernate, working with interfaces

I find that there are valid reasons for using an interface instead of a concrete class as a property. For example, if your Field class was in a seperate project to the Address class, and you didn’t have a dependency on the Address class’s project from the Field class’s project. There are other ways of … Read more

Best way to save a ordered List to the Database while keeping the ordering

Ok here is my solution to make programming this easier for anyone that happens along to this thread. the trick is being able to update all the order indexes above or below an insert / deletion in one update. Using a numeric (integer) column in your table, supported by the SQL queries CREATE TABLE myitems … Read more

Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List

Use collection interfaces instead of concrete collections, so NHibernate can inject it with its own collection implementation. In this case, use IList<int> instead of List<int>

Is this the right way to eager load child collections in NHibernate

I would like to append different point of view, not the answer how to use “future” to make only one round-trip to DB. Not sure why you need to fetch all the properties. I guess it could be 1) to be used by your code, e.g. to render UI or 2) as the API which … Read more