transactionssubsonicdelete-record

Delete related records from multiple tables using subsonic T4 templates


Using templates, how can I delete related records from multiple tables in a transaction?


Solution

  • using (TransactionScope transactionScope = new TransactionScope())
    {
      using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope())
      {
        new SubSonic.Query.Delete<Person>(new MyDB().Provider)
          .Where(PersonTable.IdColumn).IsEqualTo(1)
          .Execute();
    
        new SubSonic.Query.Delete<Basket>(new MyDB().Provider)
          .Where(BasketTable.IdColumn).IsEqualTo(1)
          .Execute();
    
        transactionScope.Complete();
      }
    }