Sql Server provider for Audit.NET library (An extensible framework to audit executing operations in .NET). Store the audit events in a SQL Table, in JSON format.
Questions tagged [audit.net.sqlserver]
7 questions
3
votes
1 answer
Using Audit.NET SqlDataProvider with Azure SQL and Managed Identity
We are using the Audit.NET SqlServer Data Provider to store Audit logs in our Microsoft SQL Server. We are currently in the progress of migrating to the use of Azure SQL with Managed Identity to access the database. We haven't been able to get…
tim6175919
- 33
- 3
2
votes
1 answer
How to log Update(IList) action as multiple audit records using Audit.net
I have to update bulk records in a table. I did it as following.
BaseRepository.cs
public IList Update(IList instance) where T : class
{
IList insertedItems = new List();
int totalCount = instance.Count;
…
Mad
- 41
- 8
1
vote
2 answers
Audit.EntityFramework: SqlException: Cannot insert explicit value for identity column
Entity Framework Core
.NET 7
SQL Server
Error:
Cannot insert explicit value for identity column in table 'AuditLogs' when IDENTITY_INSERT is set to OFF.
Info:
Identity Insert is set to ON
My Column is Identity(1,1) PRIMARY KEY
This is my first…
Whaaa
- 73
- 4
1
vote
1 answer
How to use Audit.EntityFramework.Identity for .Net 6
Identity in .Net 6 using razor pages. I want to audit ASP.NET Identity entities using Audit.EntityFramework.Identity. But I don't see any document.
I changed my ApplicationDbContext.cs
public class ApplicationDbContext : AuditIdentityDbContext
{
…
RickworkGit
- 11
- 2
1
vote
1 answer
How to track event in Audit.Net with SqlDataProvider
I'm trying to audit db actions using SqlDataProvider .
Global.asax.cs
Audit.Core.Configuration.DataProvider = new SqlDataProvider()
{
ConnectionString = "...",
Schema = "dbo",
TableName =…
Mad
- 41
- 8
1
vote
1 answer
Basic WebApi implementation with Audit.NET and C#: error EntityFrameworkCore.Internal.EnumerableExtensions
I'm just starting using Audit.NET. I download the template from
dotnet new -i Audit.WebApi.Template
dotnet new webapiaudit -E
Unfortunately, the project doesn't work. When I post a value, I have an internal server error. The description is quite…
Enrico
- 3,592
- 6
- 45
- 102
1
vote
1 answer
Unable to configure SqlDataProvider in Audit.Net when MVC multiple layered application
I have web project using ASP.Net MVC. And, project structure is
Libraries
Core
Data (I have used AuditScope to capture audit events to store them in sql that configured in web)
Services
Presentation
Web (I have a configuration class to use…
Balagurunathan Marimuthu
- 2,927
- 4
- 31
- 44