Interacting directly with SAP databases is not considered a good programming practice. As SAP database is nothing but a normal database, it can interact in any way like any ODBC technique - ADO.NET or other.
Remote Function Calls can be used to make calls to databases. ERP Connect supports RFC and can be used for reading data from tables.
In case one needs a high customization and control, one can create a custom RFC component to fetch and return the intended data.