Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Keith
2730
c# transaction log design.
posted

I am design transaction log table to keep track of inserts, deletes, etc..... in the dataset or datatable


Can you point me to an example of good design of a tranaction log so that i can reference.
What are the minimum  fields you think i need in my transaction log data table?

I want to design this feature the right away. Can someone point me in the right direction?

 

Parents
No Data
Reply
  • 53790
    posted

    Hello Keith,

    I`m not familiar with your scenario, I think that maybe the best approach is to design your transaction log on a database level  - this is not related with Infragistics.  Usually I create additional log table that contains all fields from main table plus additional fields, for example:
    -          Datetime (TimeStamp) which determine when the user made the changes
    -          UserName – which determine who made the current change
    -          Fields which can provide me information if data is edited, insert or deleted
    -          Sometimes I include fields that give me information what kind of application is used to made the changes (Windows application, PDA device, web application and so on)
    I use this approach because it is very easy to create Log table with Triggers. If you need you could apply different rules and so on. After that the database server will do all jobs and I just query the information that I need from the transaction log table.
    I hope that this information will be useful for you. If you have any questions, do not hesitate to ask me

    Regards
    Georgi

Children
No Data