ansaurus

Question

Fluent Nibernate putting a where clause in the mapping

Answer 1

+2 A:

Yes, you can use a Where constraint in Fluent NHibernate to map this. Somehting like:

HasMany(x => x.Children).Where("IsDeleted = 0");

The Where constraint should use SQL syntax not HQL. For tables that allow soft deletes it's probably easier to map a view that filters the deleted records out.

Jamie Ide 2010-02-23 16:16:11

Thank, that's what I needed but how do I specific the column in the parent object to pass to the child? If its a reference its something like References( a => a.Supplier ).Column( "SupplierNo" ); but HasMany doesn't have a Column property.

Simon G 2010-02-23 16:38:20

I'm not sure I understand the question and I'd need to know more about your model and database to give a good answer. HasMany has a KeyColumn method if you're asking how to specify the FK column on a child object.

Jamie Ide 2010-02-23 16:43:04

No I want to specify the column on the parent object as it doesnt use the primary key. My parent object has a pk, name, secondary id, this secondary links to the FK in the child. I know its not a good db design but its what I've inherited. So when I do a HasMany its passing my PK value when I want it to pass my secondary ID. Thanks

Simon G 2010-02-23 20:01:50

OK, I understand. It appears that Fluent NHibernate has added a PropertyRef method to HasMany but it's not in 1.0RTM you'll need to get a more recent build. See http://groups.google.com/group/fluent-nhibernate/browse_thread/thread/7dbe122aba8c2620/c786f369ed1ce117?show_docid=c786f369ed1ce117. You should post this as a new question so that a search will find it.

Jamie Ide 2010-02-23 22:53:51

Thanks for the link and advice. Upgrading to the latest build and propertyref worked perfectly. Thanks

Simon G 2010-02-24 09:53:14

ansaurus

tags:

views:

answers:

Fluent Nibernate putting a where clause in the mapping

related questions