public static SqlConnection GetSqlConnection() { IStorageContainer <SqlConnection> _container = DataContextStorageFactory <SqlConnection> .CreateStorageContainer(); var _connection = _container.GetObject(key); if (_connection == null || _connection.State == System.Data.ConnectionState.Closed) { _connection = new SqlConnection(conStr); _connection.Open(); _container.Store(key, _connection); } return(_connection); }
public static SqlTransaction GetSqlTransaction() { IStorageContainer <SqlTransaction> _container = DataContextStorageFactory <SqlTransaction> .CreateStorageContainer(); var tran = _container.GetObject(key); if (tran == null) { tran = SqlConnectionContextFactory.GetSqlConnection().BeginTransaction(); _container.Store(key, tran); } return(tran); }