ADO.NET 2.0 Batching and SqlDataAdapter

Pablo Castro posted an interesting piece of information about ADO.NET 2.0 Batching.

The solution for implementing batching looks very good. The problem is that you can only use it if you are using SqlDataAdapter!

In previous Whidbey releases there was a SqlCommandSet class that was supposed to let you do batching from your own code. That class is still there but marked as internal.

So, if you are using DataSets/SqlDataAdapter, then you can easily take advantage of the new batching features.

If you are using DataSets but not SqlDataAdapter, you can try using SqlDataAdapter when you need to take advantage of Batching.

If you are not using DataSets, then your batching options are much more limited. You need to concatenate commands and change parameter names, etc.

I've posted a suggestion in MSDN Feedback Center to ask for a way to use the new batching without SqlDataAdapter. It's probably way too late in the Whidbey product cycle to change that, but let's see...