public void UpsertSamplerState_insert() { var stCode = "00"; var sgCode = "01"; using (var db = CreateDataStore(methods: new[] { "STR" })) { var random = new Random(); var sg = db.Query <SampleGroupDO>("Select * from SampleGroup;").First(); var ds = new SamplerInfoDataservice_V2(db); var ss = new SamplerState() { StratumCode = stCode, SampleGroupCode = sgCode, Counter = random.Next(1000), BlockState = "blockStateTest1", InsuranceCounter = random.Next(1000), InsuranceIndex = random.Next(1000), SampleSelectorType = "ssTypeTest1", SystematicIndex = random.Next(1000), }; ds.UpsertSamplerState(ss); var ssAgain = ds.GetSamplerState(stCode, sgCode); ssAgain.Should().NotBeNull(); ssAgain.Should().BeEquivalentTo(ss); } }