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
You are getting the first error because, when you remove the items from the collection, NHibernate’s default mode of operation is to simply break the association. In the database, NHibernate tries to set the foreign key column on the child row to null. Since you do not allow nulls in that column, SQL Server raises … Read more
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>
I’m not entirely sure what you are asking regarding LINQ to SQL, but it’s certainly not the wrong approach to manually create you domain objects. You won’t get properly encapsulated domain objects if you rely on them being code generated. You have got yourself in a muddle regarding the factory pattern. As mouters has pointed … Read more
In this case the answer is pretty simple. Do not use many-to-many. Use pairing object. Exactly for the reasons you’ve mentioned: Extend the pairing object with more properties: Check here 24. Best Practices, a cite: Don’t use exotic association mappings. Good usecases for a real many-to-many associations are rare. Most of the time you need … Read more
One way how to achieve this, could be to create as many subqueries joined by AND, as many attributes must be found/related to searched files I searching for name / value The first solution works with the name/value pairs, from upper layer. I.e user selected mode to be read-only… (the second will be a bit … Read more
To give you the answer how to use batching with fluent: 1) on the colleciton HasMany<MyEntity>(x => x.Entities) .BatchSize(100); 2) on a class level public MyEntityMap() { Id(x => x…. … BatchSize(100); This corresponds with the 19.1.5. Using batch fetching
We can indeed use custom transformer. There is one, which I am using for a really very very deep projections (inlcuding dynamic objects – 5.1.13. component, dynamic-component) DeepTransformer<TEntity> Take it (if needed adjust it) and your final query could be like this // just the last lines are different var query = session.QueryOver<CourseItem>() .JoinAlias(c => … Read more
So because of limitations of the Criteria API, I decided to bend my domain classes to fit. I created an entity class for the Tag. I couldn’t even create it as a value object. It had to have its own id. I feel dirty now. But being able to construct a dynamic query without resorting … Read more
If you build Fluent from source, there is now support for filters. You use them like this: First create a class inheriting from FluentNHibernate.Mapping.FilterDefinition: using FluentNHibernate.Mapping; namespace PonyApp.FluentFilters { public class PonyConditionFilter : FilterDefinition { public PonyConditionFilter() { WithName(“PonyConditionFilter”) .AddParameter(“condition”,NHibernate.NHibernateUtil.String); } } } In your ClassMap for your class, use the ApplyFilter method: namespace PonyApp.Entities.Mappings … Read more