C Sharp Datatable Logic Equivalent

Question

ADODB Recordset to SQLClient Disconnected Datatable Mapping:

 

What will be the equivalent logic converting over to using datatbles mapping. I am trying to do a one to one mapping from recordsets to datatable even if the datatable does not have a direct correlation. I am putting document together that basically saids if you see this, do this in c sharp

 

Dim rs As New ADODB.Recordset

rs.Open "SELECT pkPeopleID, LastName FROM tblPeople", CurrentProject.Connection, adOpenStatic