|
Microsoft ADO.Net provides support for a wide range of databases types. Now there are 3 Data Providers available from Microsoft:
- SQL Provider - optimized for MS SQL Server access.
- OLE DB Provider - for access to many databases which support OLE DB.
- ODBC Provider - for access to any ODBC data source (most of database vendors support this protocol).
We have successfully run our library tests with
Oracle ,
MS SQL Server ,
Watcom SQL ,
Sybase ,
Informix ,
MS Access and
Centura SQLBase .
We support almost all of the Centura database-related features, including the bind
and into variables, not normally available in .Net enviroment. You can
see the list of supported functions here.
The technique of using Data Providers can make your application independent of database type and all you need, in order to change your database type, is the appropriate Data Provider. ADO.NET has a significant advantage over Centura in this area.
|