Article ID: 311058 - Last Review: May 13, 2007 - Revision: 2.4

INFO: Microsoft .NET Framework Does Not Support Data Access Object

View products that this article applies to.

This article was previously published under Q311058

SUMMARY

Data Access Object (DAO) libraries, which are mainly built on Component Object Model (COM) technology, are not tested with COM Interop in the Microsoft .NET Framework. Therefore, Microsoft and Microsoft Product Support Services (PSS) do not guarantee the performance of DAO when you use it with the .NET Framework.

Back to the top

MORE INFORMATION

DAO provides a framework for using code to create and manipulate databases. DAO supplies a hierarchical set of objects that use the Microsoft Jet database engine to access data and database structure in the following:

Microsoft Jet databases (.mdb).
Open Database Connectivity (ODBC) data sources by using an ODBC driver.
Installable indexed sequential access method (ISAM) databases that the database engine can read directly, such as dBASE, Paradox, and Microsoft Visual FoxPro.

The Microsoft .NET Framework uses Interop to promote interaction with COM components, COM+ services, external type libraries, and many operating system services. However, DAO is not tested and therefore not supported in the .NET Framework with COM Interop.

NOTE: Microsoft recommends that you use Microsoft ActiveX Data Objects (ADO) or Microsoft ADO.NET with Microsoft Jet OLE DB Provider to connect to an Access database from a Microsoft Visual Studio .NET application.

Back to the top

REFERENCES

For more information on DAO, refer to the following MSDN documentation:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dao360/html/dahowdataaccessoverview.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dao360/html/dahowdataaccessoverview.asp)

For more information on COM Interop, refer to the following MSDN documentation:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbdev01/html/vb01i10.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbdev01/html/vb01i10.asp)

For more information on ADO.NET objects and syntax, refer to the following topic in the Microsoft .NET Framework Software Development Kit (SDK) documentation:

Accessing Data with ADO.NET
http://msdn2.microsoft.com/en-us/library/e80y5yhx(vs.71).aspx (http://msdn2.microsoft.com/en-us/library/e80y5yhx(vs.71).aspx)

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

313590 (http://support.microsoft.com/kb/313590/EN-US/ ) INFO: Roadmap for ADO.NET

Back to the top