How do you migrate code using ADO & recordsets to Sql Server Embedded which doesn’t use recordsets but uses rowsets?

Possibly helpful links:

Extended OLEDB library : Ease of ADO, power of OLEDB

Best explanation of difference between recordset & rowset:
http://www.binarystar.co.uk/Support/VB/May97Q&A.htm
Bug report that might be insightful to how editing rowsets work (search for #299584)