static void Main(string[] args) { try { Customer customer = new Customer() { Name = "Foo", Surname = "Bar" }; using (SampleAuditEntities dbContext = new SampleAuditEntities()) { using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { InsertAuditTool insertAuditTool = new InsertAuditTool(dbContext); insertAuditTool.TestInsert(customer); //throw new Exception("Test Exception"); scope.Complete(); } } Console.WriteLine("Customer ID = " + customer.ID); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }
public InsertAuditTool(SampleAuditEntities DbContext) { this.dbContext = DbContext; }