using System; using System.Collections.Generic; using System.Linq; using System.Text; using LinqConsole; using System.Threading; namespace LinqConsole { class Program { static void Main(string[] args) { DataClasses1DataContext db = new DataClasses1DataContext(); db.Log = Console.Out; var query = from o in db.Orders join od in db.Order_Details on o.OrderID equals od.OrderID where od.Quantity > 100 select o; List table = query.ToList(); Thread.Sleep(100); table[1].ShipName = DateTime.Now.ToString(); //Customer c = new Customer(); //c.CustomerID = "1345667"; //db.Customers.Add(c); try { Console.WriteLine("-- Just About To Submit ---"); db.SubmitChanges(); } catch (Exception ex) { Console.WriteLine("Exception Thrown"); Console.WriteLine(ex.Message); } Console.ReadLine(); } } public partial class DataClasses1DataContext { partial void OnCreated() { Console.WriteLine("DataContext Created"); } partial void DeleteOrder(Order instance) { Console.WriteLine("DeleteOrder"); } partial void InsertCustomer(Customer instance) { Console.WriteLine("InsertCustomer"); } partial void InsertOrder(Order instance) { Console.WriteLine("InsertOrder"); } partial void UpdateOrder(Order instance) { Console.WriteLine("UpdateOrder"); } } public partial class Order { partial void OnShipNameChanging(string value) { Console.WriteLine("OnShipNameChanging"); } partial void OnCreated() { Console.WriteLine("OnCreated"); } partial void OnLoaded() { Console.WriteLine("OnLoaded"); } partial void OnValidate() { Console.WriteLine("OnValidate"); throw new Exception("Validate Failed for Order"); } } }