[nhusers] Mapping Many-To-One

[Xaxa Urtiz]

Hello, I have these object:


    public class Entity
    {
        public virtual int Id { get; set; }
 
        public virtual Lookup Type { get; set; }
 
        public virtual string Name { get; set; }
    }
    public class Lookup
    {
        public virtual int Id { get; set; }
         
        public virtual string Table { get; set; }
 
        public virtual string Column { get; set; }
 
        public virtual int Value { get; set; }
 
        public virtual string Name { get; set; }
    }



the object Entity.Type is an integer representing a "FK" pointing on the 
table Lookup.Value with filter on the column Table and Column so for 
exemple a request would be:

SELECT *
  FROM [Entity] e
  join [Lookup] l on l.Value = e.Type
  where l.[Table] = 'Entity' and l.[Column] = 'Type'

Do you have an idea on how to make a mapping for that ? I'vre tried 
<many-to-one but the mapping is between Entity.Type and Lookup.Id and 
filter  is not possible in many-to-one
I'm using Nhibernate V3.3.1.4000.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nhusers+unsubscr...@googlegroups.com.
To post to this group, send email to nhusers@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.