public async Task TimeoutSwitchConnection()
{
using (var conn = new NpgsqlConnection(ConnectionString))
{
if (conn.CommandTimeout >= 100 && conn.CommandTimeout < 105)
{
TestUtil.IgnoreExceptOnBuildServer("Bad default command timeout");
}
}
using (var c1 = await OpenConnectionAsync(ConnectionString + ";CommandTimeout=100"))
{
using (var cmd = c1.CreateCommand())
{
Assert.That(cmd.CommandTimeout, Is.EqualTo(100));
using (var c2 = new NpgsqlConnection(ConnectionString + ";CommandTimeout=101"))
{
cmd.Connection = c2;
Assert.That(cmd.CommandTimeout, Is.EqualTo(101));
}
cmd.CommandTimeout = 102;
using (var c2 = new NpgsqlConnection(ConnectionString + ";CommandTimeout=101"))
{
cmd.Connection = c2;
Assert.That(cmd.CommandTimeout, Is.EqualTo(102));
}
}
}
}