raptier生成后的程序数据库连接

数据库使用应采用using(MyDatabase db = new MyDatabase())的方式,不能在设计的类中定义类属变量MyDatabase db = new MyDatabase();如果采用该种方式,将导致数据库连接一直打开,占用系统内存,影响系统效率。
需要事务处理的则如示例所示。

using(MyDatabase db = new MyDatabase())
{
    // Begin the transaction
    db.BeginTransaction();
    try
    {
        // Your DB code.
        UserRow user = db.UserTable.GetByPrimaryKey("John", "Smith");
        user.City = "Dallas";
        db.UserTable.Update(user);

        user = db.UserTable.GetByPrimaryKey("Amy", "Smith");
        user.City = "Dallas";
        db.UserTable.Update(user);

        // Commit the transaction
        db.CommitTransaction();

        // Both records are updated
    }
    catch (Exception)
    {
        // Rollback the transaction
        db.RollbackTransaction();

        // Neither record was updated
    }
}