Audit.NET.MySql

MySQL provider for Audit.NET library (An extensible framework to audit executing operations in .NET).

Store the audit events in a MySQL Table.

Install

NuGet Package To install the package run the following command on the Package Manager Console:

PM> Install-Package Audit.NET.MySql

Usage

Please see the Audit.NET Readme

Configuration

Set the static Audit.Core.Configuration.DataProvider property to set the MySQL data provider, or call the UseMySql method on the fluent configuration. This should be done before any AuditScope creation, i.e. during application startup.

For example:

Audit.Core.Configuration.DataProvider = new MySqlDataProvider()
{
    ConnectionString = "Server=localhost; Database=events; Uid=admin; Pwd=admin;",
    TableName = "events",
    IdColumnName = "event_id",
    JsonColumnName = "data",
    CustomColumns = new List<CustomColumn>()
    {
        new CustomColumn("user", ev => ev.Environment.UserName)
    }
};

Or by using the fluent configuration API:

Audit.Core.Configuration.Setup()
    .UseMySql(config => config
        .ConnectionString("Server=localhost; Database=events; Uid=admin; Pwd=admin;")
        .TableName("events")
        .IdColumnName("event_id")
        .JsonColumnName("data")
        .CustomColumn("user", ev => ev.Environment.UserName));

Provider Options

• ConnectionString: The MySQL connection string.
• TableName: The table name that stores the audit events.
• IdColumnName: The column name of the event identifier (the primary key column name).
• : The column name of the event table where the event JSON will be stored. (optional)