MultiTableDataAdapter Members

[c#]
using System.Data;
using Hydrus.DataSetToolkit;

public class SimpleBank
{
    MultiTableDataAdapter hydrusAdapter = new MultiTableDataAdapter();    
    CommandBuilder hydrusBuilder = new CommandBuilder(hydrusAdapter,
        Properties.Settings.Default.SqlConnectionString,
        "System.Data.SqlClient")
    
    MyCompany.MyDataSet dataSet = new MyCompany.MyDataSet();
    
    public bool TryDepositForUser(int userID, double amount)
    {
        DbTransaction tran = cmdFactory.CreateConnection().BeginTransaction(IsolationLevel.RepeatableRead);
        MyCompany.MyDataSet.UserRow modifiedUserRow = dataHelper.FillAndFindRow(dataSet.User,tran,userID);
        hydrusAdapter.Fill(dataSet.Account,tran,new ValueWhereConstraint(dataSet.SavingsAccount.UserID,modifiedUserRow.UserID));
        dataSet.Account[0].Balance += amount;
        modifiedUserRow.LastDepositAmount = amount;
        modifiedUserRow.LastDepositDate = DateTime.Now;
        try
        {
            hydrusAdapter.Update(dataSet, ref tran, true);
            return true;
        }
        catch (Exception ex)
        {
            Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
            Console.WriteLine("  Message: {0}", ex.Message);
            // Attempt to roll back the transaction.
            try
            {
                tran.Rollback();
            }
            catch (Exception ex2)
            {
                // This catch block will handle any errors that may have occurred
                // on the server that would cause the rollback to fail, such as
                // a closed connection.
                Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
                Console.WriteLine("  Message: {0}", ex2.Message);
            }
        }
        return false;
    }
}