Audit.NET.MySql
27.0.3
dotnet add package Audit.NET.MySql --version 27.0.3
NuGet\Install-Package Audit.NET.MySql -Version 27.0.3
<PackageReference Include="Audit.NET.MySql" Version="27.0.3" />
paket add Audit.NET.MySql --version 27.0.3
#r "nuget: Audit.NET.MySql, 27.0.3"
// Install Audit.NET.MySql as a Cake Addin #addin nuget:?package=Audit.NET.MySql&version=27.0.3 // Install Audit.NET.MySql as a Cake Tool #tool nuget:?package=Audit.NET.MySql&version=27.0.3
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).
- JsonColumnName: The column name of the event table where the event JSON will be stored. (optional)
- CustomColumn: Additional columns to store information from the audit event. (optional)
Query events
This provider implements GetEvent
and GetEventAsync
methods to obtain an audit event by id
var event = mySqlDataProvider.GetEvent(1000);
Table constraints
- The table should exists.
- The table should have a single ID column (Primary key).
For example:
CREATE TABLE event
(
id INT unsigned NOT NULL AUTO_INCREMENT,
inserted_date DATETIME DEFAULT CURRENT_TIMESTAMP,
last_updated_date DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
data JSON NOT NULL,
user VARCHAR(20) NULL,
PRIMARY KEY (id)
);
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.2
- Audit.NET (>= 27.0.3)
- MySqlConnector (>= 2.3.1)
-
.NETStandard 2.0
- Audit.NET (>= 27.0.3)
- MySqlConnector (>= 2.3.1)
-
net6.0
- Audit.NET (>= 27.0.3)
- MySqlConnector (>= 2.3.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
27.0.3 | 88 | 9/25/2024 |
27.0.2 | 155 | 9/19/2024 |
27.0.1 | 130 | 9/4/2024 |
27.0.0 | 96 | 9/3/2024 |
26.0.1 | 188 | 8/22/2024 |
26.0.0 | 1,053 | 7/19/2024 |
25.0.7 | 274 | 7/4/2024 |
25.0.6 | 2,817 | 6/24/2024 |
25.0.5 | 484 | 6/18/2024 |
25.0.4 | 3,748 | 3/24/2024 |
25.0.3 | 375 | 3/13/2024 |
25.0.2 | 181 | 3/12/2024 |
25.0.1 | 977 | 2/28/2024 |
25.0.0 | 332 | 2/16/2024 |
24.0.1 | 164 | 2/12/2024 |
24.0.0 | 105 | 2/12/2024 |
23.0.0 | 7,140 | 12/14/2023 |
22.1.0 | 137 | 12/9/2023 |
22.0.2 | 1,429 | 12/1/2023 |
22.0.1 | 317 | 11/16/2023 |
22.0.0 | 158 | 11/14/2023 |
21.1.0 | 4,585 | 10/9/2023 |
21.0.4 | 7,245 | 9/15/2023 |
21.0.3 | 2,657 | 7/9/2023 |
21.0.2 | 1,210 | 7/6/2023 |
21.0.1 | 1,792 | 5/27/2023 |
21.0.0 | 5,913 | 4/15/2023 |
20.2.4 | 659 | 3/27/2023 |
20.2.3 | 437 | 3/17/2023 |
20.2.2 | 614 | 3/14/2023 |
20.2.1 | 334 | 3/11/2023 |
20.2.0 | 305 | 3/7/2023 |
20.1.6 | 1,111 | 2/23/2023 |
20.1.5 | 392 | 2/9/2023 |
20.1.4 | 4,317 | 1/28/2023 |
20.1.3 | 10,359 | 12/21/2022 |
20.1.2 | 377 | 12/14/2022 |
20.1.1 | 397 | 12/12/2022 |
20.1.0 | 653 | 12/4/2022 |
20.0.4 | 479 | 11/30/2022 |
20.0.3 | 1,401 | 10/28/2022 |
20.0.2 | 493 | 10/26/2022 |
20.0.1 | 579 | 10/21/2022 |
20.0.0 | 763 | 10/1/2022 |
19.4.1 | 3,976 | 9/10/2022 |
19.4.0 | 601 | 9/2/2022 |
19.3.0 | 567 | 8/23/2022 |
19.2.2 | 4,766 | 8/11/2022 |
19.2.1 | 605 | 8/6/2022 |
19.2.0 | 1,420 | 7/24/2022 |
19.1.4 | 4,820 | 5/23/2022 |
19.1.3 | 566 | 5/22/2022 |
19.1.2 | 623 | 5/18/2022 |
19.1.1 | 752 | 4/28/2022 |
19.1.0 | 4,713 | 4/10/2022 |
19.0.7 | 1,305 | 3/13/2022 |
19.0.6 | 2,618 | 3/7/2022 |
19.0.5 | 4,343 | 1/28/2022 |
19.0.4 | 579 | 1/23/2022 |
19.0.3 | 2,452 | 12/14/2021 |
19.0.2 | 414 | 12/11/2021 |
19.0.1 | 937 | 11/20/2021 |
19.0.0 | 489 | 11/11/2021 |
19.0.0-rc.net60.2 | 179 | 9/26/2021 |
19.0.0-rc.net60.1 | 218 | 9/16/2021 |
18.1.6 | 1,106 | 9/26/2021 |
18.1.5 | 4,066 | 9/7/2021 |
18.1.4 | 497 | 9/6/2021 |
18.1.3 | 3,059 | 8/19/2021 |
18.1.2 | 597 | 8/8/2021 |
18.1.1 | 568 | 8/5/2021 |
18.1.0 | 572 | 8/1/2021 |
18.0.1 | 559 | 7/30/2021 |
18.0.0 | 4,125 | 7/26/2021 |
17.0.8 | 628 | 7/7/2021 |
17.0.7 | 646 | 6/16/2021 |
17.0.6 | 618 | 6/5/2021 |
17.0.5 | 618 | 5/28/2021 |
17.0.4 | 602 | 5/4/2021 |
17.0.3 | 550 | 5/1/2021 |
17.0.2 | 509 | 4/22/2021 |
17.0.1 | 541 | 4/18/2021 |
17.0.0 | 871 | 3/26/2021 |
16.5.6 | 572 | 3/25/2021 |
16.5.5 | 549 | 3/23/2021 |
16.5.4 | 623 | 3/9/2021 |
16.5.3 | 544 | 2/26/2021 |
16.5.2 | 583 | 2/23/2021 |
16.5.1 | 572 | 2/21/2021 |
16.5.0 | 642 | 2/17/2021 |
16.4.5 | 1,065 | 2/15/2021 |
16.4.4 | 573 | 2/5/2021 |
16.4.3 | 525 | 1/27/2021 |
16.4.2 | 549 | 1/22/2021 |
16.4.1 | 617 | 1/21/2021 |
16.4.0 | 596 | 1/11/2021 |
16.3.3 | 576 | 1/8/2021 |
16.3.2 | 1,281 | 1/3/2021 |
16.3.1 | 676 | 12/31/2020 |
16.3.0 | 574 | 12/30/2020 |
16.2.1 | 2,087 | 12/27/2020 |
16.2.0 | 8,027 | 10/13/2020 |
16.1.5 | 814 | 10/4/2020 |
16.1.4 | 675 | 9/17/2020 |
16.1.3 | 777 | 9/13/2020 |
16.1.2 | 660 | 9/9/2020 |
16.1.1 | 652 | 9/3/2020 |
16.1.0 | 803 | 8/19/2020 |
16.0.3 | 733 | 8/15/2020 |
16.0.2 | 659 | 8/9/2020 |
16.0.1 | 695 | 8/8/2020 |
16.0.0 | 635 | 8/7/2020 |
15.3.0 | 798 | 7/23/2020 |
15.2.3 | 672 | 7/14/2020 |
15.2.2 | 2,045 | 5/19/2020 |
15.2.1 | 632 | 5/12/2020 |
15.2.0 | 706 | 5/9/2020 |
15.1.1 | 692 | 5/4/2020 |
15.1.0 | 721 | 4/13/2020 |
15.0.5 | 713 | 3/18/2020 |
15.0.4 | 711 | 2/28/2020 |
15.0.3 | 696 | 2/26/2020 |
15.0.2 | 16,208 | 1/20/2020 |
15.0.1 | 1,493 | 1/10/2020 |
15.0.0 | 1,404 | 12/17/2019 |
14.9.1 | 1,078 | 11/30/2019 |
14.9.0 | 715 | 11/29/2019 |
14.8.1 | 734 | 11/26/2019 |
14.8.0 | 752 | 11/20/2019 |
14.7.0 | 32,484 | 10/9/2019 |
14.6.6 | 748 | 10/8/2019 |
14.6.5 | 816 | 9/27/2019 |
14.6.4 | 745 | 9/21/2019 |
14.6.3 | 2,003 | 8/12/2019 |
14.6.2 | 775 | 8/3/2019 |
14.6.1 | 757 | 8/3/2019 |
14.6.0 | 770 | 7/26/2019 |
14.5.7 | 2,552 | 7/18/2019 |
14.5.6 | 11,284 | 7/10/2019 |
14.5.5 | 780 | 7/1/2019 |
14.5.4 | 785 | 6/17/2019 |
14.5.3 | 810 | 6/5/2019 |
14.5.2 | 773 | 5/30/2019 |
14.5.1 | 814 | 5/28/2019 |
14.5.0 | 809 | 5/24/2019 |
14.4.0 | 812 | 5/22/2019 |
14.3.4 | 830 | 5/14/2019 |
14.3.3 | 830 | 5/9/2019 |
14.3.2 | 858 | 4/30/2019 |
14.3.1 | 830 | 4/27/2019 |
14.3.0 | 878 | 4/24/2019 |
14.2.3 | 847 | 4/17/2019 |
14.2.2 | 7,195 | 4/10/2019 |
14.2.1 | 811 | 4/5/2019 |
14.2.0 | 2,109 | 3/16/2019 |
14.1.1 | 784 | 3/8/2019 |
14.1.0 | 3,545 | 2/11/2019 |
14.0.4 | 984 | 1/31/2019 |
14.0.3 | 923 | 1/22/2019 |
14.0.2 | 2,104 | 12/15/2018 |
14.0.1 | 1,010 | 11/29/2018 |
14.0.0 | 1,104 | 11/19/2018 |
13.3.0 | 1,498 | 11/16/2018 |
13.2.2 | 1,111 | 11/15/2018 |
13.2.1 | 1,082 | 11/13/2018 |
13.2.0 | 1,082 | 10/31/2018 |
13.1.5 | 1,112 | 10/31/2018 |
13.1.4 | 1,092 | 10/25/2018 |
13.1.3 | 1,095 | 10/18/2018 |
13.1.2 | 1,909 | 9/12/2018 |
13.1.1 | 1,130 | 9/11/2018 |
13.1.0 | 1,118 | 9/11/2018 |
13.0.0 | 7,786 | 8/29/2018 |
12.3.6 | 1,164 | 8/29/2018 |
12.3.5 | 1,177 | 8/22/2018 |
12.3.4 | 1,206 | 8/21/2018 |
12.3.3 | 26,003 | 8/21/2018 |
12.3.2 | 1,245 | 8/20/2018 |
12.3.1 | 1,218 | 8/20/2018 |
12.3.0 | 1,221 | 8/20/2018 |
12.2.2 | 1,277 | 8/15/2018 |
12.2.1 | 1,251 | 8/9/2018 |
12.2.0 | 1,206 | 8/8/2018 |
12.1.11 | 1,201 | 7/30/2018 |
12.1.10 | 1,256 | 7/20/2018 |
12.1.9 | 1,328 | 7/10/2018 |
12.1.8 | 1,272 | 7/2/2018 |
12.1.7 | 1,251 | 6/7/2018 |
12.1.6 | 1,358 | 6/4/2018 |
12.1.5 | 1,384 | 6/2/2018 |
12.1.4 | 1,417 | 5/25/2018 |
12.1.3 | 1,393 | 5/16/2018 |
12.1.2 | 1,298 | 5/15/2018 |
12.1.1 | 1,445 | 5/14/2018 |
12.1.0 | 1,387 | 5/9/2018 |
12.0.7 | 1,361 | 5/5/2018 |
12.0.6 | 1,475 | 5/4/2018 |
12.0.5 | 1,398 | 5/3/2018 |
12.0.4 | 1,490 | 4/30/2018 |
12.0.3 | 1,443 | 4/30/2018 |
12.0.2 | 1,407 | 4/27/2018 |
12.0.1 | 1,406 | 4/25/2018 |
12.0.0 | 1,376 | 4/22/2018 |
11.2.0 | 1,395 | 4/11/2018 |
11.1.0 | 1,492 | 4/8/2018 |
11.0.8 | 1,437 | 3/26/2018 |
11.0.7 | 1,312 | 3/20/2018 |
11.0.6 | 1,527 | 3/7/2018 |
11.0.5 | 1,388 | 2/22/2018 |
11.0.4 | 1,473 | 2/14/2018 |
11.0.3 | 1,426 | 2/12/2018 |
11.0.2 | 1,464 | 2/9/2018 |
11.0.1 | 1,208 | 1/29/2018 |
11.0.0 | 2,831 | 1/15/2018 |
10.0.3 | 2,842 | 12/29/2017 |
10.0.2 | 2,662 | 12/26/2017 |
10.0.1 | 2,821 | 12/18/2017 |
10.0.0 | 2,739 | 12/18/2017 |
9.3.0 | 2,858 | 12/17/2017 |
9.2.0 | 2,758 | 12/17/2017 |
9.1.3 | 4,050 | 12/5/2017 |
9.1.2 | 2,749 | 11/27/2017 |
9.1.1 | 2,725 | 11/21/2017 |
9.1.0 | 2,676 | 11/21/2017 |
9.0.1 | 2,693 | 11/11/2017 |
9.0.0 | 2,768 | 11/10/2017 |
8.7.0 | 2,716 | 11/9/2017 |
8.6.0 | 2,748 | 11/9/2017 |
8.5.0 | 2,852 | 10/3/2017 |
8.4.0 | 2,773 | 10/3/2017 |
8.3.1 | 2,708 | 9/8/2017 |
8.3.0 | 2,696 | 9/8/2017 |
8.2.0 | 2,676 | 9/4/2017 |
8.1.0 | 2,732 | 8/22/2017 |
8.0.0 | 2,907 | 8/19/2017 |
7.1.3 | 2,862 | 8/14/2017 |
7.1.2 | 2,735 | 8/2/2017 |
7.1.1 | 2,724 | 7/26/2017 |
7.1.0 | 2,687 | 7/5/2017 |
7.0.9 | 2,719 | 6/28/2017 |
7.0.8 | 2,936 | 6/19/2017 |
7.0.6 | 1,344 | 4/7/2017 |
7.0.5 | 1,329 | 3/21/2017 |
7.0.4 | 1,363 | 3/21/2017 |