数据库使用应采用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
}
}