ADO.NET data provider
ADO.NET providers can be created to access such simple data stores as a text file and spreadsheet, through to such complex databases as Oracle Database, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, IBM DB2, Sybase ASE, and many others. They can also provide access to hierarchical data stores such as email systems.
However, because different data store technologies can have different capabilities, every ADO.NET provider cannot implement every possible interface available in the ADO.NET standard. Microsoft describes the availability of an interface as "provider-specific," as it may not be applicable depending on the data store technology involved. Note also that providers may augment the capabilities of a data store; these capabilities are known as "services" in Microsoft parlance.
Components of data provider include:
- Connection: Establishes a connection to a specific data source
- Command: Executes a command against a data source
- DataReader: Reads a stream of data from a data source
- DataAdapter: Populates a data set and resolves updates with the data source
- "ADO.NET Architecture". MSDN. Microsoft. 2012-08-02. http://msdn.microsoft.com/en-us/library/27y4ybxw.aspx. Retrieved 16 July 2013.
- ".NET Framework Data Providers". MSDN. Microsoft. 2012-08-20. http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx. Retrieved 16 July 2013.
- "ADO.NET Data Providers". Data Developer Center. Microsoft. http://msdn.microsoft.com/en-us/data/dd363565. Retrieved 16 July 2013.
https://en.wikipedia.org/wiki/ADO.NET data provider was the original source. Read more.