C ++的数据库访问库 [英] Database Access Libraries for C++

问题描述

背景：

我有一个使用本地C ++编写的应用程序，它使用wxWidgets工具包的wxODBC数据库访问库，它是从的所有未来版本的wxWidgets删除。我需要替换为另一个数据库访问方法，支持下面概述的假设和约束。我不要求替换使用内置的DBMS API或ODBC，但它必须符合下面列出的约束。

假设/约束

图书馆必须：

• 支持本机


• 32位Windows 2000 / XP / 2003


• Visual Studio 2005


• Microsoft SQL Server 2000 2005


• Oracle 9和10


• 运行时性能大于或等于wxODBC


• API支持多个DBMS（例如，不想使用不同的DBMS编写不同的代码）

/ em>

• 64位Windows操作系统


• 32位和/ Linux操作系统


• Microsoft SQL Server 2008


• Oracle 11


• MySQL


• 任何额外的DBMS


• Visual Studio 2008


• 开源


• 等于本机DBMS API

问题：

库是可用的 - 免费的，开源的或付费的 - 从单一的API（包括Oracle和Microsoft SQL Server）支持多个DBMS，并且可以从本地C ++使用？

请描述您对某个特定图书馆的过去经历 - 好或坏，以及为什么对某个图书馆提出建议或反对某个图书馆，特别是上述假设和约束。

另请参阅：

http://stackoverflow.com/questions/74141/good-orm-for-c-solutions

解决方案

我使用SQLAPI ++。非常值得一看。

http://www.sqlapi.com/

Background:

I have an application written in native C++ which uses the wxWidgets toolkit's wxODBC database access library which is being removed from all future versions of wxWidgets . I need to replace this with another database access method that supports the assumptions and contraints outlined below. I don't require that the replacement use native DBMS APIs or ODBC under the hood, but it must meet the contraints outlined below.

Assumptions/Constraints

The library must:

• Support Native (i.e. unmanaged) C++
• 32-bit Windows 2000/XP/2003
• Visual Studio 2005
• Microsoft SQL Server 2000 and 2005
• Oracle 9 and 10
• Run-time Performance greater than or equal to wxODBC
• Single programmer API supporting multiple DBMS (e.g. don't want to write different code for using different DBMS)

Nice but Optional:

• 64-bit Windows operating systems
• 32-bit and/or 64-bit Linux operating systems
• Microsoft SQL Server 2008
• Oracle 11
• MySQL
• Any additional DBMS
• Visual Studio 2008
• Open Source
• Runtime Performance near or equal to native DBMS API

Question:

What good libraries are available - either free, open source or pay - that support multiple DBMS from a single API including Oracle and Microsoft SQL Server and can be used from native C++?

Please describe any past experiences you have had - good OR bad - with a given library and why you are making your recommendation for or against a given library, especially in regards to the assumptions and contraints above.

See Also:

http://stackoverflow.com/questions/74141/good-orm-for-c-solutions

解决方案

I use SQLAPI++. Well worth a look.

http://www.sqlapi.com/

这篇关于C ++的数据库访问库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！