We have a series of controls built with the True DB Grid, SEF Data Source and DB Navigator trinity.
The DB Navigator and True DB Grid have their DataSource properties set to the SEF Data Source. The DataMember property is set to the appropriate name from the ViewSource collection.
Underneath this is a .NET 4 EF EDMX that points to an Oracle Db via the ODP.NET 4 provider.
The DB Navigator exposes FIRST/PREVIOUS/NEXT/LAST/REFRESH (these are read-only datasets).
When a control is created, then visualised and the grid is populated with more than one row, we have discovered that the PREVIOUS button always navigates to row 2. Even when you are on row 2, clicking PREVIOUS appears to not change anything.
The DB Navigator exposes a button-click event, but we are not handling the event.
What we would like to establish is:
1. Is this behaviour related specifically to the SEF data source?
2. Is this behaviour related to the fact we are using a trial version to determine if the toolset will do what we need it to?
3. What if anything should we be doing in order to have PREVIOUS always move to the previous row?
When loading medium size sets of data (around 200,000 rows) we have also noticed that there is a large amount of memory consumed (over 1GB) and the load takes approx 1 minute per 50,000 rows.
How can we improve performance on larger datasets?