public void Write(OrderedItemFromList orderedItemFromList)
        {
            DynamicParameters parms = new DynamicParameters();

            parms.Add(PARMNAME_CONTROLNUM, orderedItemFromList.ControlNumber);
            parms.Add(PARMNAME_ITEMNUMBER, orderedItemFromList.ItemNumber);
            parms.Add(PARMNAME_SOURCELIST, orderedItemFromList.SourceList);

            ExecuteSPCommand(STOREDPROC_WRITE_ONE, parms);
        }
            [Fact] public void TestControlNumberAndItemNumberWriteThenRead_ReturnsExpectedSourceList()
            {
                // arrange
                var repo          = MakeRepo();
                var controlNumber = "111111";
                var itemNumber    = "123456";
                var testRecord    = new OrderedItemFromList()
                {
                    ControlNumber = controlNumber,
                    ItemNumber    = itemNumber,
                    SourceList    = "TestList"
                };
                var expected = "TestList";

                // act
                repo.Write(testRecord);
                var test = repo.Read(controlNumber, itemNumber);

                // assert
                test.SourceList
                .Should()
                .Be(expected);
            }