Hello,
I have an application that has to do Audit trail for all db changes.
I am listening to the OpenAccessContext.Events.Changed and then collecting the changes made to generate an audit record. The problem I'm having is that my Audit Entity is related to a User entity, therefore, the User entity has a list of Audits as a navigation property. When I add the new Audit record to the context, a Changed event is raised for the User object saying that the Audits property changed. When this event is raised, a select query to the database is automatically done by telerik and it retrieves all the Audit records for that User. As the user perform more operations, every submit operation in the system slows down more and more. We have new users that take around 2 secs for the same operation that old users take 3 minutes. I was not easy to find out that this was happening. I had to use the Profiling and Tuning advisor to find the issue. Is there a way to work around this???