Handle audit from the application without data base triggers RRS feed

  • Question

  • Hi,

    I need to log audit for user Insert/update/delete operation perform on the silverlight  Data Grid.

    For each Insert/Update/Delete I need to insert row for user details and what modification he has done. I have created to DML one for normal insert and one for logging audit. But if user enters 1000 rows need to log 1000 audit also it hits the performance. Is there any way to handle audit in a easy way. As per the data base expert we should not use triggers for logging.

    Please let me know any solution....


    • Edited by Intermediate-User Wednesday, March 13, 2013 9:41 AM
    • Moved by Jason Dot Wang Thursday, March 14, 2013 2:37 AM This thread is about Silverlight 5
    Wednesday, March 13, 2013 9:41 AM