Question: How does ADO.NET achieve independence from
specific database implementations?

Answer: ADO.NET distinguishes data providers from data consumers.
Thus, different provider implementations can be to address different
databases. Additionally, Microsoft offers one provider implementation
which supports OLEDB. OLEDB is the preferred interface for accessing
data sources on Microsoft operating systems and a lot of database
vendors support OLEDB.