= uda.dotnet

%TOC%

  
=  ADO.NET Data Providers

%TOC%

  ADO.NET Data Providers 
ADO.NET is the latest data-access API from Microsoft. As its name suggests, it is an evolution of Active Data Objects (ADO), built as part of the Microsoft .NET Frameworks. ADO.NET presents a very different programming model from Microsoft''s previous data-access APIs. The old connected model, in which a client program maintained a connection with the server for the duration of the application; the new paradigm underpinning ADO.NET is a disconnected model where clients only hold connects for the minimum time necessary. 

The .NET runtime and frameworks are also available for non-Windows platforms as a result of the Mono open-source project from Novell, which is committed to providing a compatible environment for developing .NET applications for cross-platform use. 

As an integral component of the .NET Frameworks, it is the standard Data-Access method for developing database centric (SQL or XML) Windows Forms applications, Web Services, and other data consuming .NET components. The Mono project also includes a full implementation of the ADO.NET Frameworks that extends the data access benefits of ADO.NET to platforms such as Linux, Mac OS X, Solaris, and HP-UX. 


 |  Platform Support |  Support for client, server, and application server operating systems  |
  

|  32- and 64-bit components |  Enables the development and utilization of 32- or 64-Bit DBMS independent applications.   

 |  Database Engine Support |  Backend database engine support  |
  

|  Broad backend Database Support |  Enables DBMS independent application utilization and deployment across a vast array of industry leading DBMS engines that includes; Oracle (7.x - 10.x), SQL Server (6.x - 2005), DB2 (6.x - 8.x), Sybase (10.x - 12.x), Progress (7.x - 10.x), Ingres (6.4 - II family), Informix (5.x - 9.x & IDS 2000), [[MySQL]]  , and [[PostgreSQL]]  .   
 

 |  Performance  |
  

|  Blistering Performance |  Delivery of data access performance levels across ODBC, JDBC, ADO.NET and OLE DB that don't compromise viability of DBMS independent application development and deployment.  |  Network Aware Record Retrieval |  Enabling the retrieval and insertion of multiple DBMS records in batches over the network with a minimal number of network hops.  |
  
 

 |  Standards Compliance  |
  

|  International character support |  Enables the development and deployment of international applications that are independent of underlying database engine.   
 

 |  Performance  |
  

|  Multithreaded |  Enables exploitation of scalability benefits arising from the use of multiple CPUs or Clusters while developing or using DBMS independent applications.   

 |  Standards Compliance  |
  

|  Supports Advanced Data Access API functionality |  Enables the development and utilization of DBMS application with DBMS independent granularity that extends to challenging areas such as scalar function calls, dates and timestamps manipulation, outer join handling, and SQL stored procedure invocation etc.   
 

----