LazyLoad(); //For disabling it add Not. prefixIt can be configured for each collection:
HasMany(x => x.user).KeyColumn("id_user").LazyLoad();
When the object use lazyload, only the item that is directly needed is fetched from the db.This item is now called persistent. For related collection items that are not used directly is implemented as a proxy.These items are called transient. After closing the Session, any direcy call to these related collection items cause exception since there is no real data in them. Therefore, it is important to do all business logic within the opened session. If a related collection is needed after closing the session, there are two ways to load required data:
1)Initialize objects:
NHibernateUtil.Initialize(myuser.cars); //it will load car collection of myuser
2)Directly call them:
Listmycars = myuser.cars; //it will load car collection into mycars. Also from now on, myuser.cars will be loaded anytime
Lazy Load is a great feature that Nhibernate provides but in some cases, it may not be the best solution in terms of performance. When an object is requested by its primary key, there is no need to load all related objects directly. However, if related items will be needed heavily, Lazy loading these items will require a new SQL query for each item requested.
As a simple test, I serialize an hierarchical data into JSON. First, the root item is fetched from db than all children are loaded recursively and serialized.Then I opened profiler and observe the number of SQL queries called by the serializer. Without lazyload, there were fewer SQL calls. In my test, lazyload results in worse performance. Nevertheless, it may not be the indicator of performance gain in all cases since loading all related data may cause loading KBs of unnecessary data. Determining best way is up to you of course.
This is realy a Nice blog post read on of my blogs It is really helpful article please read it too my blog Pinterest Button Not Working. you can visits our websites or toll free no +1-866-558-4555. solve your problem fastly.
ReplyDeleteSuch a nice blog Thanks for sharing information. It is really helpful article please read it to my blog Pinterest button not working.
ReplyDelete