Scenario is as follows : I bind llblgen pro datasource to a details view control.
Lets say it displays an address details. When I edit this address, one of the fields I have to deal with is the postcode (zipcode in some countries) field. The post code itself comes from a separate post code reference table and has about 10000 records. The post code field for editing is a templated field - using a drop down list and uses a separate LLBLGen Pro datasource to get the post code data. But as you can imagine, 10000+ records is a big problem. Also the post code reference table has a couple of columns other than the post code column and so the post code entity collection also has a few fields. Multiply this by 10000+, you get the picture.
In summary, when you have a drop down list bound to a datasource, and this drop down list can potentially have thousands of records how do you deal with it. Can you do some sort of paging?
I have tried using AJAX to populate the drop down on client side depending on some selection the user makes, but then the value selected by the user in the drop down list is not picked up by LLBLGen Pro datasource for updating.
I am using APS.NET 3.5, LLBLGen Pro 2.5 final version with Oracle 10g database.
Self-servicing two class templates are used to generate the code.