No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi all, I was thinking of using Triggers to take care of my history tables. Two questions remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private void InsertFamily(FamilyDTO) { using (TransactionScope scope = new TransactionScope()) { try { InsertFather(); InsertMother(); InsertBrother(); … |
|
Hello everybody, I was asked to design a history functionality for my database, which means that every record should be stored with a timestamp, comment (created, edited, deleted) and a user. In my eyes there are 2 possibilities: 1) Store all entries in the same table, and add created and … |