Posts Tagged ‘C#’

Transaction for OracleConnection in .Net »

1. 单个数据库连接 可以直接使用OracleTransaction对象做事务处理 using(var transaction = connection.BeginTransaction()) { .....在这个作用域上的数据库操作,必须基于这个transaction using(var command = new OracleCommand(commandText, connection) { Transaction = transaction }) { ... } ... transaction.Commit(); //transaction.Rollback(); } 2. 多个数据库连接 可以使用TransactionScope对象来维

Convert integer to Enum instance »

public void EnumInstanceFromInt() { // The .NET Framework contains an Enum called DayOfWeek. // Let's generate some Enum instances from int values. // Usually you wouldn't cast an instance of an existing Enum to an int // in order to create an Enum instance. :-) You would have the actual // integer value, perhaps a value from a database w