public void TPH_SubType_First() { using (var ctx = GetContext()) { var contracts = new List <ContractFixed>(); var c1 = new ContractFixed { AvpContractNr = "c_FIX", PackageFixedId = 1, PricesJson = "{}", MeteringPointId = 2, ClientId = 5, }; contracts.Add(c1); ctx.BulkInsert(contracts); var c1db = ctx.FixedContracts.OrderByDescending(x => x.Id).First(); Assert.AreEqual(c1.AvpContractNr, c1db.AvpContractNr); Assert.AreEqual(c1.PackageFixedId, c1db.PackageFixedId); Assert.AreEqual(c1.PricesJson, c1db.PricesJson); Assert.AreEqual(c1.MeteringPointId, c1db.MeteringPointId); Assert.AreEqual(c1.ClientId, c1db.ClientId); Assert.AreEqual(c1.ContractNr, c1db.ContractNr); Assert.AreEqual(c1.ContractSignedAt, c1db.ContractSignedAt); } }
public void TPH_BaseType() { using (var ctx = GetContext()) { var mp = new MeteringPoint { CreatedAt = DateTime.Now }; ctx.Set <MeteringPoint>().Add(mp); ctx.SaveChanges(); var contracts = new List <ContractBase>(); var c1 = new ContractFixed { AvpContractNr = "c_FIX", PackageFixedId = 1, PricesJson = "{}", MeteringPointId = mp.Id, ClientId = 5, }; contracts.Add(c1); var c2 = new ContractStock { AvpContractNr = "c_STX", Margin = 0.001m, PackageStockId = 2, MeteringPointId = mp.Id }; contracts.Add(c2); var k1 = new ContractKomb1 { AvpContractNr = "c_K1", PackageKomb1Id = 3, MeteringPointId = mp.Id }; contracts.Add(k1); var k2 = new ContractKomb2 { AvpContractNr = "c_K2", PackageKomb2Id = 3, Part1Margin = 0.1m, MeteringPointId = mp.Id }; contracts.Add(k2); ctx.BulkInsert(contracts); var c1db = ctx.FixedContracts.OrderByDescending(x => x.Id).First(); Assert.AreEqual(c1.AvpContractNr, c1db.AvpContractNr); Assert.AreEqual(c1.PackageFixedId, c1db.PackageFixedId); Assert.AreEqual(c1.PricesJson, c1db.PricesJson); Assert.AreEqual(c1.MeteringPointId, c1db.MeteringPointId); Assert.AreEqual(c1.ClientId, c1db.ClientId); Assert.AreEqual(c1.ContractNr, c1db.ContractNr); Assert.AreEqual(c1.ContractSignedAt, c1db.ContractSignedAt); var k1db = ctx.K1Contracts.OrderByDescending(x => x.Id).First(); Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr); Assert.AreEqual(k1.PackageKomb1Id, k1db.PackageKomb1Id); Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr); Assert.AreEqual(k1.MeteringPointId, k1db.MeteringPointId); Assert.AreEqual(k1.ClientId, k1db.ClientId); Assert.AreEqual(k1.ContractNr, k1db.ContractNr); Assert.AreEqual(k1.ContractSignedAt, k1db.ContractSignedAt); } }