Found the answer to part 2: the choice between system.data.sqlclient and microsoft.data.sqlclient is made at the time of specifying the connection/data source.