public static void CreateDB() { using (InheritanceMappingContext db = new InheritanceMappingContext()) { if (!db.Database.Exists()) { db.Database.Initialize(true); db.Database.CreateIfNotExists(); db.Dispose(); } } }
public static void GetAllCreditCard() { InheritanceMappingContext db = new InheritanceMappingContext(); foreach (var rec in db.BillingDetails.OfType <CreditCard>()) { foreach (var pro in rec.GetType().GetProperties()) { Console.WriteLine($"{pro.Name}: {pro.GetValue(rec)}"); } } Console.ReadLine(); }
public static void AddBankAccount() { CreateDB(); InheritanceMappingContext db = new InheritanceMappingContext(); db.BillingDetails.Add(new BankAccount() { Number = "10", NumberA = 10.ToString(), Owner = "me", BankName = "Nordea", Swift = "3333" }); db.SaveChanges(); db.Dispose(); }
public static void AddCreditCard() { CreateDB(); InheritanceMappingContext db = new InheritanceMappingContext(); db.BillingDetails.Add(new CreditCard() { CardType = 1, ExpiryMonth = "Feb", ExpiryYear = "2020", Number = "10", NumberA = 10.ToString(), Owner = "me" }); db.SaveChanges(); db.Dispose(); }