A group blog from members of the VB team
Connection Modifier Changes
In the Beta 1 build of VS 2005 we expose the Connection as Friend.
Friend ReadOnly Property Connection() As System.Data.SqlClient.SqlConnection
When developers need more advanced support for changing the connection object, the Transaction or CommandCollection they can use the Partial Class and add their own DataConnection property and implement as they wish. If the DataConnection was exposed as Settable, then the user would need to iterate through the CommandCollection and set each Connection of each command.
Transaction Property removed:
The code we currently generate for the Transaction property on the TableAdapters doesn’t work in all scenarios. While we could do some more work to make this a bit better, the real value is to enable transactions between two specific methods, and even abstract the amount of code the user needs to write. For instance, the developer should just be able to call an Update method which in turn updates two ore more tables within a transaction. All set through the designer. Because we have several bugs on the Transaction property as currently defined, and we’re concerned about the expectation of this property, we’ll be removing it. Developers can still add their own Transaction property to the their TableAdapters through partial classes. I hope to have a snippet completed to make this easier as well.
These changes should appear in the first Technology Preview post Beta 1.
PingBack from http://richnewman.wordpress.com/2007/03/04/connection-management-with-tableadapters-in-net-20visual-studio-2005/
PingBack from http://restaurants.247blogging.info/?p=622
PingBack from http://www.keyongtech.com/445951-modify-created-connection-string