"Sal DiStefano" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> I am looking to see how others have approached this. I have a large VB6
> codebase using ADO. in most places we used updatebatch to update our
> recordsets.
> As I am looking to move to .NET and I look at ADO.NET I don't see
> equivilent functionality to the update batch method. I see that I now have
> to create update,insert,delete and select commands for my interactions
woth
> the database. I can use a dataset and dataAdapter or use SQLCommands, etc
> but it just is a whole lot more code.
> anyone have a pointer to something I'm missing here?
>

The key object you're missing is the CommandBuilder.
ADO "figured out" the insert update and delete commands based on the row
metadata.

In ADO.NET this job is done by the CommandBuilder.

Just attach a CommandBuilder to your DataAdapter, and you can update
DataSets without coding DML statements, just like in ADO.

David

Hi

I am looking to see how others have approached this. I have a large VB6
codebase using ADO. in most places we used updatebatch to update our
recordsets.
As I am looking to move to .NET and I look at ADO.NET I don't see
equivilent functionality to the update batch method. I see that I now have
to create update,insert,delete and select commands for my interactions woth
the database. I can use a dataset and dataAdapter or use SQLCommands, etc
but it just is a whole lot more code.
anyone have a pointer to something I'm missing here?

Thanks

Sal