Fluent NHIbernate sits on top of NHibernate, so its not really a choice between the two. If youre going to use NHibernate, CHOOSE to use Fluent NH on top of it to save yourself vast amounts of effort. Fluent NHibernate is awesome, I wouldn’t use NHibernate without it. You can fluently map all your entities … Read more
The reference provided by Brian explains it quite clearly. However, the main difference is that Load doesn’t hit the database to check and load the entity you require, since it assumes you know the entity exists. The object returned by Load is some kind of proxy that lazily fetches the real data when required or … Read more
In the TearDown of my UnitTests, I mostly do this: using( ISession s = … ) { s.Delete (“from Object o”); s.Flush(); } This should delete all entities. If you want to delete all instances of one specific entity, you can do this: using( ISession s = …. ) { s.Delete (“from MyEntityName e”); s.Flush(); … Read more
I have manage to achieve such dynamic search criterion by using Criteria API’s. Problem I ran into was duplicates with inner and outer joins and especially related to sorting and pagination, and I had to resort to using 2 queries, 1st query for restriction and using the result of 1st query as ‘in’ clause in … Read more
This is a well known issue with NHibernate handling nvarchar(max), see : http://geekswithblogs.net/lszk/archive/2011/07/11/nhibernatemapping-a-string-field-as-nvarcharmax-in-sql-server-using.aspx For some years now, I have been file mapping nvarchar(max) columns to StringClob without encountering any problem : <property name=”myProp” column=”MY_PROP” not-null=”true” type=”StringClob” access=”property”></property> This link (from the comments) describes the fluent mapping required to fix this issue: https://www.tritac.com/nl/blog/fluent-nhibernate-nvarchar-max-fields-truncated-to-4000-characters/ Map(x => x.Description).CustomType(“StringClob”).CustomSqlType(“nvarchar(max)”);
You can put something like this in your app.config/web.config file : in the configSections node : <section name=”log4net” type=”log4net.Config.Log4NetConfigurationSectionHandler,log4net”/> in the configuration node : <log4net> <appender name=”NHibernateFileLog” type=”log4net.Appender.FileAppender”> <file value=”logs/nhibernate.txt” /> <appendToFile value=”false” /> <layout type=”log4net.Layout.PatternLayout”> <conversionPattern value=”%d{HH:mm:ss.fff} [%t] %-5p %c – %m%n” /> </layout> </appender> <logger name=”NHibernate.SQL” additivity=”false”> <level value=”DEBUG”/> <appender-ref ref=”NHibernateFileLog”/> </logger> </log4net> … Read more
To get a bidirectional association with a not-null foreign key column in the Details table you can add the suggested Owner property, a References(…).CanNotBeNull() mapping in the DetailsMap class, and make the Summary end inverse. To avoid having two different foreign key columns for the two association directions, you can either specify the column names … Read more
I would claim that, like most things, its a sliding scale. There are things that we make that want to have the property of persistence. On one end of the scale is this thing having all of the guts, dependencies, and code that is custom built to persist just this one thing in its particular … Read more
[UPDATE] Please see the following links for a version of that uses RealProxy to proxy the SqlCommand – batching is now supported blog http://blog.fearofaflatplanet.me.uk/mvcminiprofiler-and-nhibernate-take-2 gist https://gist.github.com/1110153 I’ve left the original answer unaltered as it was accepted. [/UPDATE] I’ve managed to partially get this to work by implementing a Profiled Client Driver (example for Sql Server … Read more
You could use the NHibernate Disjunction class to do this in a more elegant (IMHO) fashion: var disjunction= new Disjunction(); disjunction.Add(Restrictions.On<Type>(e => e.Code).IsLike(codePart)); disjunction.Add(Restrictions.On<Type>(e => e.Description).IsLike(codePart)); //(and so on) and then: query.Where(disjunction) Each “OR” is a separate instruction, which helps if you want to add the predicates conditionally.