nceADO.NET is an implementation of Active Data Object(ADO) interface in .NET.
ADO.NET model is much different from ADODB, and can not migrate from ADODB to ADO.NET directly. Netcoole provides nceADO.NET so that the migration is easy and quick. nceADO.NET keeps the ADODB model in .NET, so the ASP programmer can understand the ASP.NET program, which contains the nceADO.NET codes, without any difficulty.
nceADO.NET is written in C#, and based on ADO.NET. It has all benefits of ADO.NET.
| Namespace | Description |
| nce.adoole | Connecting to an OLE DB Data Source. It uses the OLE DB .NET
Data Provider. Recommended for middle-tier applications using Microsoft SQL Server 6.5 or earlier, or any OLE DB provider. Recommended for single-tier applications using Microsoft Access databases. Use of a Microsoft Access database for a middle-tier application is not recommended. SQLOLEDB and Microsoft.Jet.OLEDB.4.0 Providers are tested with Netcoole nceADO.NET. |
| nce.adosql | Connecting to SQL Server. It uses The SQL Server .NET Data Provider. Recommended for middle-tier applications using Microsoft SQL Server 7.0 or later. Recommended for single-tier applications using Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0 or later. |
| nce.adoora | Connecting to Oracle. It uses the .NET Framework Data Provider for Oracle. |
Following is the list of the relationship between ADO and nceADO.NET:
| ADODB | Netcoole's nceADO.NET |
| ADODB.CONNECTION | |
| ADODB.COMMAND | |
| ADODB.FILED | |
| ADODB.RECORDSET | |
| ADODB.ERROR | |
| ADODB.PARAMETER | |
| ADODB.PROPERTY | |
| ADODB.Feilds | |
| ADODB.Properties | |
| ADODB.Parameters | |
| ADODB.ERRORS | |
| ADODB.RECORD | Unsupported |
| ADODB.STREAM | Unsupported |
| ADODB Collections | Unsupported |