The Connection class seems straightforward enough.....but

When the Command object executes a SQL query.....where's the cursor?
Or would this typically be used to issue Update/Delete commands and let the RecordSet do the queries?

Does one choose the Command object vs the RecordSet object solely based on whether the methods in the RecordSet object are needed when doing a SQL query?

What is the relationship between these 3 or are they separate entites simply using the connection as established by the Connection class?

Thanks,
Steve