Database Independence

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.