public void Insert_with_null_value()
{
TestContext.Run(engine => {
TableWithNullableColumn foo = new TableWithNullableColumn()
{
Name = "TableWithNullableColumn"
};
engine.Insert(foo);
Assert.NotEqual(0, foo.Id);
List <TableWithNullableColumn> list = engine.Select <TableWithNullableColumn>().ToList();
Assert.Equal(1, list.Count);
Assert.Equal("TableWithNullableColumn", list[0].Name);
Assert.False(list[0].CreatedDate.HasValue);
});
}
public void Update_new_value_is_null()
{
TestContext.Run(engine => {
TableWithNullableColumn foo = new TableWithNullableColumn()
{
Name = "TableWithNullableColumn1", CreatedDate = NOW
};
engine.Insert(foo);
foo.CreatedDate = null;
int affectedRows = engine.Update(foo);
Assert.Equal(1, affectedRows);
List <TableWithNullableColumn> list = engine.Select <TableWithNullableColumn>().ToList();
Assert.Equal(1, list.Count);
Assert.False(list[0].CreatedDate.HasValue);
});
}
