public void Can_convert_ModelWithFieldsOfNullableTypes() { var model = ModelWithFieldsOfNullableTypes.Create(1); var toModel = Serialize(model); ModelWithFieldsOfNullableTypes.AssertIsEqual(toModel, model); }
public void Can_Serialize_populated_model_of_NullableTypes() { var model = ModelWithFieldsOfNullableTypes.Create(1); var json = JsonSerializer.SerializeToString(model); var fromJson = JsonSerializer.DeserializeFromString <ModelWithFieldsOfNullableTypes>(json); ModelWithFieldsOfNullableTypes.AssertIsEqual(model, fromJson); }
public void Can_insert_and_select_from_ModelWithFieldsOfNullableTypes_table() { using (var db = OpenDbConnection()) { db.CreateTable <ModelWithFieldsOfNullableTypes>(true); var row = ModelWithFieldsOfNullableTypes.Create(1); db.Insert(row); var rows = db.Select <ModelWithFieldsOfNullableTypes>(); Assert.That(rows, Has.Count.EqualTo(1)); ModelWithFieldsOfNullableTypes.AssertIsEqual(rows[0], row); } }
public void Can_insert_and_select_from_ModelWithFieldsOfNullableTypes_table() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.CreateTable <ModelWithFieldsOfNullableTypes>(true); var row = ModelWithFieldsOfNullableTypes.Create(1); db.Insert(row); var rows = db.Select <ModelWithFieldsOfNullableTypes>(); Assert.That(rows, Has.Count.EqualTo(1)); ModelWithFieldsOfNullableTypes.AssertIsEqual(rows[0], row); } }
public void Can_DeleteNonDefaults_entity_with_nullable_DateTime() { db.DropAndCreateTable <ModelWithFieldsOfNullableTypes>(); var row = ModelWithFieldsOfNullableTypes.Create(1); row.NDateTime = null; db.Save(row); row = db.SingleById <ModelWithFieldsOfNullableTypes>(row.Id); var rowsAffected = db.DeleteNonDefaults(row); Assert.That(rowsAffected, Is.EqualTo(1)); row = db.SingleById <ModelWithFieldsOfNullableTypes>(row.Id); Assert.That(row, Is.Null); }
public void Can_DeleteNonDefaultsAll_entity_with_nullable_DateTime() { db.DropAndCreateTable <ModelWithFieldsOfNullableTypes>(); var rows = 3.Times(i => ModelWithFieldsOfNullableTypes.Create(i)); rows.Each(x => x.NDateTime = null); db.SaveAll(rows); db.Save(ModelWithFieldsOfNullableTypes.Create(3)); // extra row shouldn't be deleted rows = db.SelectByIds <ModelWithFieldsOfNullableTypes>(rows.Map(x => x.Id)); var rowsAffected = db.DeleteNonDefaults(rows.ToArray()); Assert.That(rowsAffected, Is.EqualTo(rows.Count)); rows = db.SelectByIds <ModelWithFieldsOfNullableTypes>(rows.Map(x => x.Id)); Assert.That(rows.Count, Is.EqualTo(0)); }