SDAC vs ADO.NET 2

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mlsam
Posts: 3
Joined: Tue 19 Jun 2007 16:35

SDAC vs ADO.NET 2

Post by mlsam » Tue 19 Jun 2007 16:43

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".)
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 20 Jun 2007 10:23

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.
Top
mlsam
Posts: 3
Joined: Tue 19 Jun 2007 16:35

SQLDirect .NET vs SDAC

Post by mlsam » Wed 20 Jun 2007 15:10

You mean the performance of SDAC is better than SQLDirect .NET?
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 20 Jun 2007 16:12

Yes, our tests show that this is true, but I would suggest you to compare performance of these products yourself in your environment.
Top
Post Reply

Return to “SQL Server Data Access Components”