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:
Bug report that might be insightful to how editing rowsets work (search for #299584)