Page 1 of 1
SDAC vs ADO.NET 2
Posted: Tue 19 Jun 2007 16:43
by mlsam
What are the advantages and disadvantages of SDAC over ADO.NET 2 for accessing SQL Server?
(Note: we are considering either to use "Delphi 7 to access to SQL server" or "migrate to Visual Studio to access to SQL Server".)
Posted: Wed 20 Jun 2007 10:23
by Antaeus
ADO 2 is an universal technology, whereas SDAC is specialized in SQL Server. This allows SDAC to gain high performance (in many cases SDAC is several times faster than ADO 2), and easy to implement server-specific features. But because of some VCL peculiarities SDAC can not implement certain minor SQL Server features all the same. One more SDAC benefit is rich design-time editors.
SQLDirect .NET vs SDAC
Posted: Wed 20 Jun 2007 15:10
by mlsam
You mean the performance of SDAC is better than SQLDirect .NET?
Posted: Wed 20 Jun 2007 16:12
by Antaeus
Yes, our tests show that this is true, but I would suggest you to compare performance of these products yourself in your environment.