The Visual Basic Team : Transactional Update using TableAdapters at Restaurants

The Visual Basic Team : Transactional Update using TableAdapters at Restaurants — Mon, 31 Dec 2007 09:57:50 GMT

PingBack from http://restaurants.247blogging.info/?p=513

re: Transactional Update using TableAdapters

Jeff Davis — Tue, 31 Aug 2004 23:10:00 GMT

This seems like a reasonable implementation given the design of the TableAdapter components. I think the manageability of the partial class approach would be improved with a good code snippet, as was suggested on the MSDN Feedback Center.

I think if I were to implement this pattern in my application I would want to do the following:

1) Create an Interface that has the AdapterTransaction property.
2) Implement a code snippet to add the stock logic to implement this interface on every table adapter we create.
3) Always require developers to explicitly set the AdapterTransaction and Connection properties anytime they do a fill or save operation.