/* update customer details */ public static void UpdateCustomer() { LinqToSQLDataContext db = new LinqToSQLDataContext(); CustomerData customer = db.CustomerDatas.FirstOrDefault(c => c.FirstName.Equals("xyz")); customer.FirstName = "pqr"; db.SubmitChanges(); }
/* insert customer function */ public static void InsertCustomer(string customerFirstName, string customerLastName, string customerEmailId, string customerPhoneNumber) { LinqToSQLDataContext db = new LinqToSQLDataContext(); CustomerData customer = new CustomerData(); customer.FirstName = customerFirstName; customer.LastName = customerLastName; customer.EmailId = customerEmailId; customer.PhoneNumber = customerPhoneNumber; db.CustomerDatas.InsertOnSubmit(customer); db.SubmitChanges(); }