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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
