I use spring and hibernate a lot in java, here is what I did in .NET do make them work together. Let's consider a file named contextDal.xml :
<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/xsd/spring-objects.xsd">
<object type="Spring.Objects.Factory.Config.PropertyPlaceholderC onfigurer, Spring.Core">
<property name="ConfigSections" value="databaseSettings"/>
</object>
<object id="dbProvider" type="Spring.Data.Support.SqlProvider, Spring.Data">
<property name="ConnectionString" value="Data Source=${datasource.connection.server};Initial Catalog=${datasource.connection.database};User Id=${datasource.connection.userId};Password=${data source.connection.password}"/>
</object>
<object id="sessionFactory" type="Spring.Data.Orm.NHibernate.LocalSessionFactoryObje ct, Spring.Data.Orm.NHibernate">
<property name="DbProvider" ref="dbProvider"/>
<property name="HibernateProperties">
<dictionary>
<entry key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<entry key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
<entry key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
</dictionary>
</property>
<property name="MappingAssemblies">
<list>
<value>MyAssembly</value>
</list>
</property>
</object>
<object id="hibernateTransactionManager" type="Spring.Data.Orm.NHibernate.HibernateTransactionMan ager, Spring.Data.Orm.NHibernate">
<property name="DbProvider" ref="dbProvider"/>
<property name="sessionFactory" ref="sessionFactory"/>
</object>
</objects>
Just replace MyAssembly by your assembly.
Then, write a test class which extend Spring.Data.Orm.NHibernate.HibernateTemplate and inject the sessionFactory in in this class :
<object id="testClass" type="test.TestClass, MyAssembly">
<property name="SessionFactory" ref="sessionFactory"/>
</object>
in a method of your test class, try to run this following piece of code :
IList results = base.Find("select e from app.model.Product ");
where app.model.Product design a class mapped by Hibernate in a cfg.xml file.
For transaction management, let's consider a context file dedicaded to business layer (contextService.xml) :
<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/xsd/spring-objects.xsd">
<object id="serviceTemplate" type="Spring.Transaction.Interceptor.TransactionProxyFac toryObject, Spring.Data" abstract="true">
<property name="PlatformTransactionManager" ref="hibernateTransactionManager"/>
<property name="TransactionAttributes">
<name-values>
<add key="create*" value="PROPAGATION_REQUIRED"/>
<add key="update*" value="PROPAGATION_REQUIRED"/>
<add key="delete*" value="PROPAGATION_REQUIRED"/>
<add key="attach*" value="PROPAGATION_REQUIRED"/>
</name-values>
</property>
</object>
<object id="productsManager" type="Spring.Transaction.Interceptor.TransactionProxyFac toryObject, Spring.Data" parent="serviceTemplate">
<property name="target" ref="productsManagerTarget"/>
</object>
<object id="productsManagerTarget" type="foo.service.ProductsManager, MyAssembly">
<!-- additionnal injections -->
</object>
</objects>
Then, everything which happen in a method flagged a transactionnal of a proxied service is embeded in a transaction.
Do not forget to join the 2 context files in a single file (using <import resource="contextDal.xml"/> and <import resource="contextService.xml"/>).
And be carefull to properly embed your mapping file in the assembly at build time (for each hbm file, set the property "BuildAction" at "Embedded Resource").
Last but not least, spring expect nhibernate 1.0.1 so if you use 1.0.2, write this in the app.config :
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="NHibernate" publicKeyToken="154fdcb44c4484fc" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-1.0.2.0" newVersion="1.0.2.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
Good luck !
PS : question to the team, is there a schedule for Spring.Data.Orm.NHibernate release ?