Yesterday My colleague told me that using data adapter to insert data into an sql server database is not reliable, because it does not guarantee that data are inserted properly. He also told me that if the data insertion is unsuccessful, it does not show any kind of error message.
I am really confused. I thought microsoft invented ado.net so that data can be inserted into the database without any extra hazard.
What do you guys think? Is data adapter unreliable?