In my project's earlier version I used Stored Procedures (SPs) & directly used them inside presentation layer. SP contains multiple Insert & Update queries for multiple tables.
Now I have decided to use a DAL(Typed DataSets & TableAdapters)
How can i use the same SPs with TableAdapters or If not possible how to wrap Multiple TableAdapters inside Transactions.
1 more thing in my earlier version i was using Transaction in SPs & Presentation Layer.
View Complete Post