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