In the past I've always use ADODB in vb.net for accessing data. I use PervasiveSQL which supports adCmdTableDirect so it allows me to move up and down tables, edit, delete create new records etc.

I thought it was about time I looked at taking the SQL approach. What I can't get my head around is which method to use, you've go system.data.oledb, system.data.odbc and system.data.sqlclient. On top of that there's seems to be no recordset to retrieve a SQL query into, so is it possible to have a local recordset to work on and make changes or do you just issue SQL UPDATE commands?

If somebody could shed some light on the best method I would appreciate it and any decent links to exampes.

Thanks