Hi,
I'm new to ADO.net. We have classes like SQLDataAdapter and SQLDataReader. Inside SQLDataAdapter we have something called as "Selectcommand", "InsertCommand", etc. I wish to know the basic difference in these options. Is this related to isolation level?

Also how can we mention isolation level in the connection object?

Thanks,

Hi Varshan,

The different commands are used by the dataadapter to interface with the database. For example when you update the data from a data adapter the InsertCommand, UpdateCommand and DeleteCommand will run.

Hope this helps

During Update, if this property is not set and primary key information is present in the DataSet, the InsertCommand can be generated automatically if you set the SelectCommand property and use the OleDbCommandBuilder.

As far as isolation goes, you need to use transactions. Each command will have a property that can be set as a transaction objec (you can use different transaction objects or the same one) and changes are isolated until you commit the transaction, or rolled back if the transaction is aborted.