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);
