ADO.net UPDATE advise...

[AlexCode]

Hi...

I want to ask you guys whats the best way to update a database using ADO.net.
Im not using Datasets, nor DataAdapters.

I have my own IDBCommand objects, trying to keep it as DBProvider independant as possible.

My main question is: having the 3 records save commands (Insert, Update & Delete), and a bunch of rows to update (a DataRow collection),
whats the best code to apply the commands on the rows?

Thanks,

Alex

 

[Machaira]

I dont understand. If youre using your own objects to handle it, it sounds like you just need to loop through the rows, check the RowState member and apply the correct command.