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 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(); }
public void CreateDatabaseTest() { var database = new NpgsqlDatabase(ConnectionString); database.Should().Not.Be.Null(); }