static void Main(string[] args) { using (var db = new AccountingSystemContainer()) { var invHeader = db.InvoiceHeaders.Create(); var invDetail = db.InvoiceDetailSet.Create(); invHeader.Total = 150m; invDetail.ItemDescription = "Some Item"; invDetail.Price = 75m; invDetail.Quantity = 2; invHeader.InvoiceDetail.Add(invDetail); db.InvoiceHeaders.Add(invHeader); db.SaveChanges(); var a = db.InvoiceHeaders; foreach (var c in db.InvoiceHeaders) { Console.WriteLine(c.Total); } Console.ReadKey(); } }
static void Main(string[] args) { using (var db = new AccountingSystemContainer()) { var invHeader = db.InvoiceHeaders.Create(); var invDetail = db.InvoiceDetails.Create(); invHeader.Total = 250m; invDetail.Description = "New Descritpion"; invDetail.Price = 95m; invDetail.Quantity = 3; invHeader.InvoiceDetails.Add(invDetail); db.InvoiceHeaders.Add(invHeader); db.SaveChanges(); } using (var dbread = new AccountingSystemContainer()) { var iheader = new InvoiceHeader(); var results = from i in dbread.InvoiceDetails where i.InvoiceDetail_Id == 1 select i; foreach (var item in results.ToList()) { Console.WriteLine(" ID: \t\t {0} \n Description: \t {1} \n Price: \t {2} \n Quantity: \t {3} \n \n", item.InvoiceDetail_Id, item.Description, item.Price, item.Quantity); } Console.WriteLine(iheader.Total + " " + iheader.InvoiceHeader_Id); Console.WriteLine(); Console.WriteLine(); Console.Read(); } Console.Read(); }