public void NullableProperty()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TYPE pg_temp.nullable_property_type AS (foo INT)");
conn.ReloadTypes();
conn.MapComposite <NullablePropertyType>();
var expected1 = new NullablePropertyType {
Foo = 8
};
var expected2 = new NullablePropertyType {
Foo = null
};
using (var cmd = new NpgsqlCommand(@"SELECT @p1, @p2", conn))
{
cmd.Parameters.AddWithValue("p1", expected1);
cmd.Parameters.AddWithValue("p2", expected2);
using (var reader = cmd.ExecuteReader())
{
reader.Read();
Assert.That(reader.GetFieldValue <NullablePropertyType>(0).Foo, Is.EqualTo(8));
Assert.That(reader.GetFieldValue <NullablePropertyType>(1).Foo, Is.Null);
}
}
}
}
public void NullableProperty()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TYPE pg_temp.nullable_property_type AS (foo INT)");
conn.ReloadTypes();
conn.MapComposite<NullablePropertyType>();
var expected1 = new NullablePropertyType { Foo = 8 };
var expected2 = new NullablePropertyType { Foo = null };
using (var cmd = new NpgsqlCommand(@"SELECT @p1, @p2", conn))
{
cmd.Parameters.AddWithValue("p1", expected1);
cmd.Parameters.AddWithValue("p2", expected2);
using (var reader = cmd.ExecuteReader())
{
reader.Read();
Assert.That(reader.GetFieldValue<NullablePropertyType>(0).Foo, Is.EqualTo(8));
Assert.That(reader.GetFieldValue<NullablePropertyType>(1).Foo, Is.Null);
}
}
}
}
