partial void DeleteShipper(Shipper instance);
 partial void UpdateShipper(Shipper instance);
 partial void InsertShipper(Shipper instance);
 public Shipper CreateShipper(Shipper shipper)
 {
     var dc = new DataClassesDataContext(_connectionString);
     dc.Shippers.InsertOnSubmit(shipper);
     dc.SubmitChanges();
     return shipper;
 }
 public Shipper UpdateShipper(Shipper shipper)
 {
     var dc = new DataClassesDataContext(_connectionString);
     dc.Shippers.Attach(shipper, ReadShipper(shipper.ShipperID));
     dc.SubmitChanges();
     return shipper;
 }
 public void DeleteShipper(Shipper shipper)
 {
     var dc = new DataClassesDataContext(_connectionString);
     IQueryable<Shipper> s = from e in dc.Shippers
                             where e.ShipperID == shipper.ShipperID
                             select e;
     dc.Shippers.DeleteOnSubmit(s.First());
     dc.SubmitChanges();
 }