nhibernate join table value function

Question

I'm discovering nhibernate right now. Thus my question is maybe very stupid :)

What I'm trying to do (I'm working with a legacy database) is to get an entity which some of its data are coming from a table value function. My entity is the following

public class Entity
{
  public virtual int Id { get; protected set; }
  ....
  public virtual int AccessRightId { get; set; }
}

where AccessRightId comes from the table value function (fp_AccessRight('userId'))

I have the following mapping

public class EntityMap : ClassMap<Entity>
  {
    public EntityMap ()
    {
      this.Id(entity => entity .Id);          
      this.Join(
          "fp_AccessRight('userId')",
            join =>
            {
                join.Fetch.Join();
                join.KeyColumn("EntityId");
                join.Map(t => t.AccessRightId, "AccessRightType");
                join.Table();
            });
    }        
}

Unfortunately, I'm not able to substitute 'userId' by any value. Thanks. Is there a way to do it?

you could post it as answer and accept it so others find it more easily — Firo
– Firo, Commented Sep 5, 2012 at 12:04

bregell · Accepted Answer · 2012-09-10 08:32:16Z

1

I finally solved it.

The trick was to make the join like this :

this.Join("fp_ACCOUNT_ACL(:AclFilter.userId)"

and then simpley to enable the filter

this.session.EnableFilter("AclFilter").SetParameter("userId", "bdd#5");

I found an example here.

answered Sep 10, 2012 at 8:32

bregell

817 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

nhibernate join table value function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related