Log Data Changes in Entity Framework - Part 3 - Ignore, Reference, SQL Server JSON & Testing

Показать описание

We have integrated the ability log data changes in Entity Framework, but we need to make a few changes.

To think about database and table size, we need to ignore properties that we don't wish to log data changes to.

As well, if an entity is related to a reference, then we need to able to log data changes for that.

Then, we will look at SQL Server's JSON functionality, so we can translate keys in a JSON string to SQL columns so we can create a SQL query.

Lastly, we will look at the importance of testing in an application like this.

📖 Learn .NET and C# with our online courses 📖

#entityframework #sqlserver

Рекомендации по теме

Комментарии

Another question that's on my mind: have you implemented anything like this where you could revert to the previous update? Like a rollback button for each change recorded.

markachternaam

If you want the data to be returned as data columns through the OPENJSON statement, why not store it in the SQL Server as column based data instead of JSON?

markachternaam

Log Data Changes in Entity Framework - Part 3 - Ignore, Reference, SQL Server JSON & Testing

Log Data Changes in Entity Framework - Part 1 - Create Entities and DbContext's

Log Data Changes in Entity Framework - Part 3 - Ignore, Reference, SQL Server JSON & Testing

How To Track Entity Changes With EF Core | Audit Logging

Log Data Changes in Entity Framework - Part 2 - Service Integration For Testing With An API

Audit Logging in Entity Framework: Best Practices and Implementation Tips in C#

Tracking data changes in Entity Framework Core with ASP .NET Core 6.0

C# : Implementing Audit Log / Change History with MVC & Entity Framework

How to easily enable SQL Logging in Entity Framework Core in a .Net Core Application

How to Track the Entity Changes with Hibernate Events | JPA Buddy

Entity Framework Core 6 - Easy Audits with Temporal Tables

How to view the SQL generated by the Entity Framework Core? Enable Sensitive Data Logging

The Ultimate Guide To Handling Data With Entity Framework (2024)

Managing Temporal Data with Entity Framework in C#

Spring Data JPA - Publishing Domain Events When Changing an Entity

Entity Framework Core Unchained Getting the Best Performance from Your ORM - Dan Mallott

C# : Entity Framework Core: Log queries for a single db context instance

Entity Framework Core In-Depth Part 9

Tips n Tricks Part 134 - Is Log Sequence Number a Quantum Entity ?

History of Entity Framework | Pluralsight

Hibernate Tip : How to detach an entity from the persistence context

Entity Framework Core #52 - Logging

[Entity Framework] Logging Query eseguite da DataContext

Schockierend! DevCouch Video - Entity Framework Logging und Interception

Active Record Business Layer with and Entity Framework in C#