I'm using a stronly typed dataset built with the Visual Studio dataset designer for a .Net 2.0 application (cannot move above 2.0 unfortunatly)
On a simple level my database has two tables, Persons and Addresses. An Address record has a foriegn key to a Person from the Persons table.
When a new Person is created an Address is also inserted for the Person, I'd like this to be in a single transaction that can be committed or rolledback using the tableadapters.
This approach seems very close: http://www.codeproject.com/KB/dotnet/transactionta.aspx
This method is failing when the dataset is set to Refresh records on Insert/Update, but I need this Refresh to pull the ScopeIdentity and update the dataset so I know the new ID of a created record in Persons or Addresses.
View Complete Post