public static MedicineRepresentorsObject Create(RepresentorObject representor, MedicineObject medicine, DateTime?validFrom = null, DateTime?validTo = null) { var o = new MedicineRepresentorDbRecord { Representor = representor?.DbRecord ?? new RepresentorDbRecord(), Medicine = medicine?.DbRecord ?? new MedicineDbRecord(), ValidFrom = validFrom ?? DateTime.MinValue, ValidTo = validTo ?? DateTime.MaxValue }; o.RepresentorID = o.Representor.ID; o.MedicineID = o.Medicine.ID; return(new MedicineRepresentorsObject(o)); }
public static void Initialize(SentryDbContext c) { c.Database.EnsureCreated(); if (c.MedicineRepresentors.Any()) { return; } foreach (var a in c.Medicines) { foreach (var p in c.Representors) { var x = new MedicineRepresentorDbRecord() { RepresentorID = p.ID, MedicineID = a.ID, }; c.MedicineRepresentors.Add(x); } } c.SaveChanges(); }