I used to do all the database logic with SqlCommand and the Methodes ExecuteReader and ExecuteNonReader and never used something like DataSet or Datatable.

```
Dim dbcon As Data.Common.DbConnection
Dim cmdselect = dbcon.CreateCommand()
cmdselect.CommandText = "SELECT * FROM users WHERE id = 1"
cmdselect.ExecuteReader()

Dim cmdupdate = dbcon.CreateCommand()
cmdselect.CommandText = "UPDATE FROM useres WHERE id = 1 SET name = 'newname'"
cmdselect.ExecuteNonQuery()

```

This is sometimes hard to administrate. So I would like to use a more efficent way. May thought was to Query a DataTable, make changes to it and then call .AcceptChanges and all changes where wrote back to the Database. But this seems not to be the way it works?
The method .Update requires that i bring with my own update command, if i have to do that myself, why using the datatable, dataset... anyway?

How do you write your DB Backend?

* With SQLCommands arrays and variables?
* With DataSet, DataTable?
* With a VisualStudio genereated template?
* With Linq?

I really don't know which way to go....