public void Ensure_we_can_match_on_properties_ignoring_nulls() { var item = new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = 33 }; var testTableItems = new[] { new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = 31 }, item, new TableWithAutoIncrementPrimaryKey { Name = "Michael", SomeNumber = 33 }, new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = null }, new TableWithAutoIncrementPrimaryKey { Name = null, SomeNumber = 33 } }; DataBaseScriptRunnerAndBuilder.InsertTableWithAutoGeneratedPrimaryKey(Connection, testTableItems); var oldNumber = item.SomeNumber; item.SomeNumber = null; var results = Sut.GetExactMatches(item, true); Assert.AreEqual(3, results.Count()); Assert.AreEqual(3, results.Count(t => t.Name == item.Name)); Assert.AreEqual(1, results.Count(t => t.SomeNumber == oldNumber)); Assert.AreEqual(1, results.Count(t => t.SomeNumber is null)); }
public void Ensure_we_can_match_on_properties_withNull() { var item = new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = null }; var testTableItems = new[] { new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = 31 }, item, new TableWithAutoIncrementPrimaryKey { Name = "Michael", SomeNumber = 33 }, new TableWithAutoIncrementPrimaryKey { Name = null, SomeNumber = 33 } }; DataBaseScriptRunnerAndBuilder.InsertTableWithAutoGeneratedPrimaryKey(Connection, testTableItems); var results = Sut.GetExactMatches(item, false); Assert.AreEqual(1, results.Count()); var test = results.First(); Assert.IsNotNull(test); Assert.AreEqual(item.Name, test.Name); Assert.AreEqual(item.SomeNumber, test.SomeNumber); }
public async Task Ensure_we_Can_Get_correct_record_Back_when_id_is_a_number_diff_name() { var testTableItems = new[] { new TableWithAutoIncrementPrimaryKey { Name = "Michale", SomeNumber = 33 }, }; DataBaseScriptRunnerAndBuilder.InsertTableWithAutoGeneratedPrimaryKey(Connection, testTableItems); var record = DataBaseScriptRunnerAndBuilder.GetAll <TableWithAutoIncrementPrimaryKey>(Connection).First(); var item = await Sut.GetById(new TableWithAutoIncrementPrimaryKeyDiffSqlName { Id = record.Id }); Assert.IsNotNull(item); Assert.AreEqual(record.Id, item.Id); Assert.AreEqual(testTableItems.First().SomeNumber, item.SomeNumber); Assert.AreEqual(testTableItems.First().Name, item.Name); }