Is there a way to create a lazy custom property with NHibernate?

Question

I have a custom property (to binding in a Grid) like that :

public class MyClass
{ 
       public virtual IList<clsClass2> MyList{ get; set; }  //Lazy loaded
       public virtual string CustomProperty //To use on Grid Binding
       {
          get
          {
             if (!MyList.IsNullOrEmpty())
                return MyList.Select(__comp => __comp.Name).ToList().ToString(", ");
                return string.Empty;
          }
       }   
}

Its working fine... But that way everytime I load a MyClass object, its load every MyList element because of the CustomProperty...

Is there a better way to do that?

Thanks

lazyloaded property whith formula

Firo
– Firo

2012-03-09 12:22:13 +00:00
Commented Mar 9, 2012 at 12:22 — Firo
– Firo, Commented Mar 9, 2012 at 12:22

Community · Accepted Answer · 2017-05-23 12:21:12Z

1

 public virtual string CustomProperty //To use on Grid Binding
 {
    get; private set;
 }

// using FLuentMapping
Map(x => x.CustomProperty).Formula("(SELECT ... FROM Class2Table c2 WHERE c2.MyClass_id = Id)");

and exchange ... with your database syntax of aggregating the string see here

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Mar 9, 2012 at 15:12

Firo

30.8k4 gold badges57 silver badges97 bronze badges

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

1 Comment

Paul Over a year ago

Tried using XML PATH, but got an error... I found that : nhibernate.jira.com/browse/NH-2132 ... So I think I cannot use XML PATH on NHibernate Formula.... Is there any other way?

Collectives™ on Stack Overflow

Is there a way to create a lazy custom property with NHibernate?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related