1. Home
  2. LLBLGen Pro
  3. Bugs & Issues

[SOLVED] Infragistics

Posts   
 
    
jeffreygg
User
Posts: 805
Joined: 26-Oct-2003
# Posted on: 19-Nov-2003 23:51:13   

Anyone have problems with binding entity collections to the Infragistics UltraGrid? We haven't done a lot of testing so I don't know exactly where it fails, but bascially the application just hangs when you set the datasource of the grid, not at databind(). We're using UltraGrid 2003 v2.

Jeff...

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39928
Joined: 17-Aug-2003
# Posted on: 19-Nov-2003 23:53:58   

It can be the same error Component One's grid had, it had a bug in the property retrieval routine. I don't have the infragistics control here, so I can't test it...

Frans Bouma | Lead developer LLBLGen Pro
Ruizzie avatar
Ruizzie
User
Posts: 34
Joined: 14-Oct-2003
# Posted on: 20-Nov-2003 08:46:05   

Hi Jeff,

We are using the Infragistics UltraGrid v3 and for us it hung too initially (although I am not sure it hangs when assigning the DataSource).

SQL Profiler revealed that exessive amounts of queries were being made. This was due to the hierarchical nature of the UltraGrid. I don't believe we have circular relations in our database but it simply kept on quering. We managed to fix this by setting MaxBandDepth to 1 instead of to the default 100. Higher MaxBandDepths were possible too, but past 2 or 3 it was quering all over the place again.

Apart from this binding to EntityCollections or TypedLists has not been a problem for us.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39928
Joined: 17-Aug-2003
# Posted on: 20-Nov-2003 09:13:47   

Ah, so it sees collections of a given type and reads them... that's indeed causing a lot of queries (which load objects which have collections etc... you pull your complete database). I'll add the MaxBandDepth to the Faq.

Frans Bouma | Lead developer LLBLGen Pro
jeffreygg
User
Posts: 805
Joined: 26-Oct-2003
# Posted on: 23-Nov-2003 03:23:07   

Thanks, all, for the replies.

Jeff...

Ruizzie avatar
Ruizzie
User
Posts: 34
Joined: 14-Oct-2003
# Posted on: 13-Apr-2004 16:38:11   

On closer investigation, this behaviour turned out to be caused by the 'ManyToMany' properties. These can lead to circular references and therefor make the databinding process of the UltraWinGrid go on forever.

We chose to disable the ManyToMany properties but to leave the ManyToMany functions operational. With this the grids work even with larger banddepths (like four or five) and there's almost no loss of functionality.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39928
Joined: 17-Aug-2003
# Posted on: 13-Apr-2004 17:09:22   

Good tip! simple_smile

Frans Bouma | Lead developer LLBLGen Pro
New User
User
Posts: 1
Joined: 16-Mar-2004
# Posted on: 21-Apr-2004 12:24:47   

Hi

I have faced a very strange problem. I had installed LLBL Gen Pro in my d: (i.e. non-system drive). The SD.LLBL.Pro dll is not getting generated in my project. Though after a little struggle I found the problem and reinstalled in the system drive and now it is working fine. But is that was the real problem.

stuck_out_tongue_winking_eye

csmith12
User
Posts: 33
Joined: 08-Dec-2003
# Posted on: 18-May-2004 19:21:44   

How did you disable the many to many features?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39928
Joined: 17-Aug-2003
# Posted on: 18-May-2004 20:04:43   

csmith12 wrote:

How did you disable the many to many features?

I think via a custom template change.

Frans Bouma | Lead developer LLBLGen Pro