Esempio n. 1
0
        private static void QueryBillingModel()
        {
            EfInheritanceContext db = new EfInheritanceContext();

            Console.WriteLine("Billing Item number: " + db.Billings.Count());

            foreach (var billing in db.Billings)
            {
                Console.WriteLine("\tBilling: " + billing.Id + ", " + billing.Number + ", " + billing.Owner);
            }
            Console.WriteLine();

            Console.WriteLine("CreditCard Item number: " + db.CreditCards.Count());
            foreach (var creditCard in db.CreditCards)
            {
                Console.WriteLine("\tCreditCard: " + creditCard.Id + ", " + creditCard.Number + ", " + creditCard.Owner + ", " + creditCard.CardType + "," +
                                  creditCard.ExpiryYear + ", " + creditCard.ExpiryMonth);
            }
            Console.WriteLine();

            Console.WriteLine("BankAccount Item number: " + db.BankAccounts.Count());
            foreach (var bankAccount in db.BankAccounts)
            {
                Console.WriteLine("\tBankAccount: " + bankAccount.Id + ", " + bankAccount.Number + ", " + bankAccount.Owner + ", " + bankAccount.BankName + "," +
                                  bankAccount.Swift);
            }
            Console.WriteLine();
        }
Esempio n. 2
0
        private static void CreateCustomerModel()
        {
            EfInheritanceContext db = new EfInheritanceContext();

            VipCustomer cc = new VipCustomer
            {
                Name   = "VipCustomer",
                VipNum = 999
            };

            db.Customers.Add(cc);

            SupperCustomer ba = new SupperCustomer
            {
                Name       = "SupperCustomer",
                SupperNums = 888,
            };

            db.Customers.Add(ba);
            db.SaveChanges();
        }
Esempio n. 3
0
        private static void CreateBillingModel()
        {
            EfInheritanceContext db = new EfInheritanceContext();

            CreditCard cc = new CreditCard
            {
                CardType    = CardType.CreditCard,
                ExpiryMonth = 11,
                ExpiryYear  = 2015,
                Number      = 11,
                Owner       = "Owner"
            };

            db.CreditCards.Add(cc);
            db.Billings.Add(cc);


            BankAccount ba = new BankAccount
            {
                BankName = "CCNC",
                Number   = 9,
                Owner    = "CN",
                Swift    = 88
            };

            db.BankAccounts.Add(ba);

            BillingDetail bd = new BillingDetail
            {
                Number = 101,
                Owner  = "Billing"
            };

            db.Billings.Add(bd);

            db.SaveChanges();
        }