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


The information in this article applies to:

  • Microsoft .NET Framework
  • Microsoft .NET Framework 1.1
  • Microsoft Windows .NET Framework 1.1
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.

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.

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

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

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://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaccessingdatawithadonet.asp

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

313590 INFO: Roadmap for ADO.NET

Modification Type:MajorLast Reviewed:9/4/2003
Keywords:kbinfo kbJET KB311058
©2003 Microsoft Corporation. All rights reserved.