SQL Server MFC DAO classes and MFC ODBC classes

Most MFC developers are familiar with Open Database Connectivity (ODBC) database classes-they appear as early as 3.5. In MFC 4.2, there are some important improvements to these classes.

As a C + + developer, you may not be familiar with DAO because it is only available to Microsoft Access and visual basic® programming systems so far. If you are familiar with DAO, you must understand that DAO's implementation in MFC is quite different, but it is extensive.

Developers who understand the MFC ODBC classes must know that although the MFC DAO analogy ODBC classes are more functional, DAO classes cannot replace them.

For those who are not familiar with MFC, I would like to remind you that MFC has a design principle that applies to a variety of database classes.

MFC, like a thin wrapping paper, encapsulates the windows® operating system API, providing the C + + performance you want, while providing the abstract concepts you need. Add a value to the underlying API when it has real meaning. But most of the time MFC tries to keep it untouched.

Just as MFC encapsulates more complex APIs, database classes encapsulate more complex techniques. Because MFC can move values between Intel, UNIX, and Alpha, the database application solution is also a removable value.

We use the same recordset model with Microsoft Access and Visual Basic, so developers who already use those products don't have to learn new paradigms. In addition, the architecture of the two-class set is essentially the same, and developers using one of the class sets can easily switch to another class set and use it.

MFC Database Classes

ODBC database classes have been included in MFC since version 1.5. Visual C + + version 2.0 provides a 32-bit version containing the same class. These classes are based on an industry accreditation standard and have been widely used, and are favored by other database development options because of their portability of ODBC. This portability refers to the ability to use many ODBC data sources with applications created with these classes. Recent performance improvements have made ODBC database classes an attractive option.