What is a good api to sql from visual c++

I want to do simple stuff like adding entries and reading entries by index. What libraries are there a开发者_开发技巧nd which ones are the best?

SQLite would be a good simple SQL database engine, with a simple embedded C++ interface.

SQLAPI++ would be a good choice for many commercial SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQLite and ODBC)

One option is to use Microsoft's SQL Server Compact Edition. It is free, and has Visual Studio integration.

You can download it and find out more at the following link: SQL Server Compact Edition

If you not worried about HUGE concurrency then use SQLite (www.sqlite.org). Download the aggregated version and you only have 2 files: sqlite3.h and sqlite3.c. It's REALLY easy to use and requires no server set up or configuration.