static void Main() { DataContext db = new DataContext(@"Data Source=S20440\SQLEXPRESS;Initial Catalog=TestingDatabase;Integrated Security=True;Connect Timeout=60"); var i = (db.GetTable<Invoice>().Select(inv => inv));//.Single<Invoice>(); var ii = db.GetTable<Invoice>().Where(inv => inv.Invoice_Amount > 7.00M).Select(inv => inv); foreach (Invoice invoice in i) { invoice.Invoice_Posted = false; } SaveChanges(db); Invoice invo = new Invoice {Invoice_Amount = 333.44M, Invoice_Date = DateTime.Now}; db.GetTable<Invoice>().InsertOnSubmit(invo); SaveChanges(db); }
partial void UpdateInvoice(Invoice instance);
partial void DeleteInvoice(Invoice instance);
partial void InsertInvoice(Invoice instance);