Jul 5, 2015 at 2:55 PM
Edited Jul 5, 2015 at 3:40 PM
It is very hard to access a SQL Server from C++.
C++ 11, 14, and 17 have (or will soon have) a lot of modern features, but, alas, it is very time consuming accessing data in a SQL Server.
Most available libraries exhibit poor quality, or are incomplete. Microsoft's own way for accessing SQL Servers involves mostly C code and not C++. The available samples are few, and only cover a handful of cases, which are not even the most commonly required.
In C++, pages of code are required to implement even the simplest SQL access method, such as reading a single table row. The same code would require just few lines when written in C# using the Enterprise Library 6.
Considering that database access is present in almost all programs being developed today, porting, at least, the DAAL to C++ would be a very valuable proposition. Lots and lots of developers would benefit from it.
The Data Access Application Block abstracts the actual database in use, and exposes a series of methods that make it easy to access that database to perform common tasks. This would be a serious time saving for C++ developers. Lots of duplicated code would
be avoided, and the final product quality would be vastly improved.
I have already made this suggestion in person to the Microsoft VS C++ team, during the last year's Build conference. They liked the idea very much, but nothing has surfaced so far about a DAAB porting to C++.
This would, certainly, be a huge success in the C++ community, and a big winner for the Pattern & Practices Group.