nceADO is an implementation of Active Data Object(ADO) interface in .NET. Vb6TOCS provides three options 'ado to nce.adosql', 'ado to nce.adoole' and 'ado to nce.adoora' to migrate from the ADODB to .NET.
ADO.NET model is much different from ADODB, and can not migrate from ADODB to ADO.NET directly. Netcoole provides nceADO so that the migration is easy and quick. nceADO keeps the ADODB model in .NET, so the VB programmer can understand the .NET program, which contains the nceADO 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 |