Difference of ADO.net in version 1 and 2
ADO.net in ver 2 has many new features compared to ver 1.
Comparison of ADO.net in ver 1 and ver 2
- Ver 2 supports disconnected architecture
- 2 more providers in ver2. (eg. Oracle provider )
- Multiple active result sets in ver 2
- Asynchronous access in ver 2
- Ver 2 Supports bulk copy