c# - Audit Logging Inserts -
i wondering if offer input implementation of audit logging inserts. need ensure transactional. i have audit dbset built upon following poco: public class audit { public int id { get; set; } public user user { get; set; } public datetime created { get; set; } public string type { get; set; } public int entityid { get; set; } public string message { get; set; } } i have dbset, users, when insert want create automatically add audit entity in audit dbset. consider following code: //var user = new user(); //user.created = datetime.now; //user.username = "testuser"; //user.password = "testpassword"; //datacontext.users.add(user); var post = new post(); post.created = datetime.now; post.title = "a sample post"; post.published = true; post.body = "some content goes in here..."; datacontext.posts.add(post); var audit = new audit(); audit.created = datetime.now; audit.user = currentuser.user; // logged in user audit.t...