ADO.NET
This article includes a list of general references, but it lacks sufficient corresponding inline citations. (March 2009) |
Ms-RSL) | |
---|---|
Website | docs |
ADO.NET is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components.[1] ADO.NET is a set of computer software components that programmers can use to access data and data services from a database. It is a part of the
Architecture
ADO.NET is conceptually divided into consumers and data providers.[2] The consumers are the applications that need access to the data, and the providers are the software components that implement the interface and thereby provide the data to the consumer.
Functionality exists in
A provider is a software component that interacts with a
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.
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. Providers may augment the capabilities of a data store; these capabilities are known as "services" in Microsoft parlance.
Object-relational mapping
Entity Framework
Entity Framework (EF) is an open source object-relational mapping (ORM) framework for ADO.NET, part of .NET Framework. It is a set of technologies in ADO.NET that supports the development of data-oriented software applications. Architects and developers of data-oriented applications have typically struggled with the need to achieve two very different objectives. The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, such as customers and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is stored. With the Entity Framework, developers can work at a higher level of abstraction when they deal with data, and can create and maintain data-oriented applications with less code than in traditional applications.
LINQ to SQL
LINQ to SQL (formerly called DLINQ) allows
References
- ^ "ADO.NET Overview". docs.microsoft.com. Microsoft. Retrieved 4 September 2017.
- ^ "ADO.NET Architecture". docs.microsoft.com. Microsoft. Retrieved 4 September 2017.
- "ADO.NET Architecture". MSDN. Microsoft. 2012-08-02. Retrieved 16 July 2013.
- ".NET Framework Data Providers". MSDN. Microsoft. 2012-08-20. Retrieved 16 July 2013.
- "ADO.NET Data Providers". Data Developer Center. Microsoft. Retrieved 16 July 2013.