public void CreateConnectionTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); using(var connection = (NpgsqlConnection)database.CreateConnection()) { connection.Open(); connection.State.Should().Be(ConnectionState.Open); } }
private static void HandleConnectionError(NpgsqlDatabase db, Exception ex, int? tryCount) { if(log.IsErrorEnabled) { log.Error("Database Connection 생성 및 Open 수행 시에 예외가 발생했습니다. ConnectionString=[{0}]", db.ConnectionString); log.Error(ex); } With.TryAction(() => NpgsqlConnection.ClearAllPools()); var timeout = Math.Min(MaxTimeout, Math.Abs(tryCount.GetValueOrDefault(1)) * 50); Thread.Sleep(timeout); }
public void CreateConnectionTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); using (var connection = (NpgsqlConnection)database.CreateConnection()) { connection.Open(); connection.State.Should().Be(ConnectionState.Open); } }
public void ExecuteReaderTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); using(var connection = (NpgsqlConnection)database.CreateConnection()) { connection.Open(); connection.State.Should().Be(ConnectionState.Open); using(var cmd = new NpgsqlCommand("SELECT * FROM Invoices", connection)) { using(var reader = cmd.ExecuteReader()) { Console.WriteLine(reader.ToString(true)); } } } }
public void ExecuteReaderTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); using (var connection = (NpgsqlConnection)database.CreateConnection()) { connection.Open(); connection.State.Should().Be(ConnectionState.Open); using (var cmd = new NpgsqlCommand("SELECT * FROM Invoices", connection)) { using (var reader = cmd.ExecuteReader()) { Console.WriteLine(reader.ToString(true)); } } } }
public void CreateDatabaseTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); }