Hi all,

I'm using the multi-column combo box from TMS software in SelfServicing (http://www.tmssoftware.com/site/aspnet_multicolumncombobox.asp).

This control supports the use of a datasource. I also have a database with lots of relations.

I use the column box to have the user select a value from a table that is related to some other tabels. I want to show only two or three field from that table.

When I run the web application in debug mode, I see that using this control results in lots of selects on related fields. I was expecting a simple SELECT A, B from TABLE.

Is this behaviour caused by LLBLGen datasource or is this behaviour caused by the control. Assuming this is caused by LLBLGen, how can I prevent this.

Regards,

Jan

PS. I am currently not using the datasource, but filling the control in the pageload method. This does exactly what I want, but requires a few lines of coding.

Could you please post more information? (LLBLGen generated SQL, declatarive aspx of the controls, LLBLGen version), so we could determine what's going on.

Additionally, maybe you are seeing the selfservicing's lazy loading nature. Have you read about how could you improve your scenario using Prefetch paths?

I have read about the prefetch paths. I think the normal behaviour of LLBLGen is to only retrieve the entities from 1 table in the database. Related entities are only retrieved when being accessed in the code.

That's what I was expecting it would do.

I'm only using basic field to show in the multi column drop down. When I change the multi column dropdown in a plain dropdown control, there is no problem. Therefor I think it is caused by the TMS control. When I fill it programmatically, there is no problem.

Guess I leave it like that.

Thanks,