Hi,

We are new to LLBLGen and using the trial version of LLBLGen to setup the DAL and auditing feature. The documentation explains clearly how the auditing class works, but we have some confusion on the below aspects:

1. What are the fields in the AuditInfo table? Dow we create this table manually in the database?
2. Can we extend the fields in the AuditInfo table to include username?
3. Can we store the AuditInfo table in a separate database from the production database.

Do you have any working example/tutorial of the auditing feature that writes to MS SQL Server? This will help us a lot in understanding the auditing functionality better. I did see some references to an exmple project on the website, but could not find a link to it.

Any help will be appreciated.

Thank you, Girish.

girishnuli wrote:

1. What are the fields in the AuditInfo table? Dow we create this table manually in the database?

Hi Girish. The documentation and example only show one way you can do auditing, in that case is into a table called AuditInfo, but you can do whatever you need inside the auditor. You can audit into a text file, for instance. You can send the log to a web service, etc. So LLBLGen only produces the plumbing, you write your audit logic.

girishnuli wrote:

1. Can we extend the fields in the AuditInfo table to include username?

You can do your AuditInfo table as you wish, then you refresh the LLBLGen desiger and regenerate the code.

girishnuli wrote:

1. Can we store the AuditInfo table in a separate database from the production database.

Yes.

girishnuli wrote:

Do you have any working example/tutorial of the auditing feature that writes to MS SQL Server? This will help us a lot in understanding the auditing functionality better. I did see some references to an exmple project on the website, but could not find a link to it.

Here are the examples: http://llblgen.com/Pages/ListAdditionalDownloads.aspx#6 , There is an Auditing example.

Thank you David. The example project helped in understanding the auditing concepts better.

Regards, Girish.