/// <summary> /// Insert new order /// returns the newly added key. /// </summary> /// <param name="dr">data row</param> /// <returns>ID of new record</returns> public int InsertNewOrder(OrderDataSet.OrdersRow dr) { int NewOrderID; using (OrdersTableAdapter ta = new OrdersTableAdapter()) { dr.OrderPk = Guid.NewGuid(); NewOrderID = (int)ta.InsertOrderRecord(dr.OrderPk) ; } return NewOrderID; }How should I use the PK later for details insertion?
public int InsertNewOrder(OrderDataSet.OrdersRow dr) >{ > OrdersTableAdapter ta = new OrdersTableAdapter(); > dr.OrderPk = Guid.NewGuid(); > > return (int)ta.InsertOrderRecord(dr.OrderPk, dr.OrderDate); >}Are you saying that you have two primary keys? A GUID and a ID? Why?
>/// <summary> >> /// Insert new order >> /// returns the newly added key. >> /// </summary> >> /// <param name="dr">data row</param> >> /// <returns>primary key of new record</returns> >> public int InsertNewOrder(OrderDataSet.OrdersRow dr) >> { >> OrdersTableAdapter ta = new OrdersTableAdapter(); >> >> return (int)ta.InsertOrderRecord(dr.OrderPk, dr.OrderDate); >> }>In my case the Orders table has PK as GUID (I want to allow simple merge), ID as Integer Identity and an OrderDate.