I have ben involved in a project that was a very slow migration frm vb6 to vb.net. The systems were extremely huge and the custom software project successful for them. My question is what are the reasons I should advocate SQLconnection vs the older established ado libraries. I have been using the managed sql conn providers for years now and stopped using adodb more than10 years ago.
I guess my question is why advocate doing this? Will ado eventually go away? The amounts of data transfer are fairly light. We are not dealing with big data here. The product has been successful it's clients do not care what connection methods are under the hood.