Thank you for getting back to us and for the additional information.
As far as I understand the situation, currently when you do SaveChanges the rows of the grid are reloaded one by one, which I confirm is quite slow.
A much performant approach that allows you display the latest state of the database is to reload the data with just one SELECT statement. if you find this feasible, you can review a sample implementation in our WPF Quick Start Scenario
. It consumes plain List<T> collections to hold the binding data and the INotifyPropertyChanged interface for communication with the UI. With this approach, once the changes are committed to the database, the whole collection is retrieved with a single SELECT, and when you apply some filtering, only the relevant data are fetched with just one statement.
I hope this helps. Let us know how the things on your side are.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map