public void NonQueryProcedureShouldModifyEntity() { var updateRoutineArgs = new UpdateRoutineParameters { Id = 1, }; var nonQuery = new NonQueryStoredProcedure <UpdateRoutineParameters>(this.Fixture.Connector); nonQuery.ExecuteNonQuery(updateRoutineArgs); var searchClientArgs = new SearchParentTableParameters { ParentName = "Test Parent ChangedNameTest", Active = true }; var results = new ReaderStoredProcedure <SearchParentTableParameters, SingleKeyParentTable>(this.Fixture.Connector).Execute(searchClientArgs); results.Should().NotBeNull(); results.Should().HaveCount(1); results[0].Name.Should().Be("Test Parent ChangedNameTest"); }
public void ShouldRetrieveTwoResultsOnInactiveClients() { var args = new SearchParentTableParameters { ParentName = "Test Par", Active = false }; var results = new ReaderStoredProcedure <SearchParentTableParameters, SingleKeyParentTable>(this.Fixture.Connector).Execute(args); results.Should().NotBeNull(); results.Should().HaveCount(2); var activeParentEntity = this.Fixture.CreateNewInactiveEntity(); foreach (var entity in results) { entity.Name.Should().StartWith("Test Parent"); entity.ShouldBeEquivalentTo(activeParentEntity, options => options.Excluding(o => o.Name) .Excluding(o => o.Id) .Excluding(o => o.Childs)); } }