How much writing vs. reading of this table(s) do you expect? I’ve used a single audit table, with columns for Table, Column, OldValue, NewValue, User, and ChangeDateTime – generic enough to work with any other changes in the DB, and while a LOT of data got written to that table, reports on that data were … Read more
IF you are using EF 4 you can subscribe to the SavingChanges event. Since Entities is a partial class you can add additional functionality in a separate file. So create a new file named Entities and there implement the partial method OnContextCreated to hook up the event public partial class Entities { partial void OnContextCreated() … Read more
Ignoring the comment about the REST style mapping CRUD to the HTTP methods, this is an excellent question. The answer to your question is, yes you are free to use PUT in this scenario even though there are some elements of the resource that are updated by the server in a non-idempotent manner. Unfortunately, the … Read more
I just want to call out couple of points: Use code generators You can’t have a single procedure to track all tables, you will need to generate similar but distinct triggers on each tracked table. This kind of job is best suited for automated code generation. In your place I would use an XSLT transformation … Read more
The Audits tab does not exist anymore, it has been replaced with Lighthouse (See What’s new in DevTools (Chrome 83)). Just use Lighthouse.
Yarn doesn’t have npm audit fix. But here’s how to do it by using npm – temporarily. Generate a package-lock.json file without installing node modules npm i –package-lock-only Fix the packages and update the package-lock.json file npm audit fix Delete the yarn.lock file and convert package-lock.json file into yarn.lock rm yarn.lock yarn import Delete the … Read more
Support for –production flag was released in npm 6.10.0 https://github.com/npm/cli/pull/202 npm audit –production The –omit flag was added in npm 7.x and is now preferred. https://docs.npmjs.com/cli/v8/commands/npm-audit/#omit npm audit –omit=dev
Use “Insert Only Databases” The basic idea is that you never update or delete data. Each table has 2 datetime columns from and to. They start with the value null in each (beginning of time to end of time) When you need to “change” the row you add a new row, at the same time … Read more
If using EF6’s DbContext you can use ChangeTracker in SaveChanges override to find added/modified entities of custom type, for example IAuditedEntity. public interface IAuditedEntity { string CreatedBy { get; set; } DateTime CreatedAt { get; set; } string LastModifiedBy { get; set; } DateTime LastModifiedAt { get; set; } } public override int SaveChanges() { … Read more
Have you tried SET NOCOUNT OFF?