What's the difference between using ADO.NET class like DataAdapter to insert/update records in table or using command.ExecuteNonQuery(); What's the difference in their behaviou and which one should be used?