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));
}
}
}
}