dbGo or dbExpress for Delphi 2010 with Microsoft SQL Server

Question

I am migrating to Delphi 2010 and I am using Microsoft SQL 2000 (Planning on upgrading to SQL2008). I have been using BDE all along and wondering if I should use dbGo (ADO) or dbExpress with my future application. Can someone explain to me the pros and cons for using either one?

Thanks a lot.

Answer 1

I've recently had exactly the same dilemma, wondering whether to move away from ODBCExpress to ADO or dbExpress which are more supported out-of-the-box.

My decision was very simple in the end, as it was made for me: dbExpress is uni-directional, designed for executing queries, not for cursor-style movement through a dataset. You have to add extra support in order to use grids and other db-aware controls, by using the TDataSetProvider and TClientDataSet components. So it can be done but the extra layers ruled it out for me.

Zarko Gajic has an excellent article on it on his delphi.about.com site.

I'm sure others will disagree and that's good, I welcome the discussion.

Answer 2

For performance reason and future development I will go with dbExpress.

dbExpress has been pushed up since latest version, but dbGo didn't changed since Delphi 5 or 6, and it's include just few fixing with each version, while dbExpress has been getting more improvment with each versions specially in last few releases.

another options is to use SDAC from DevArt, it's has the best performance and has more advanced features for Sql server compared to other technologies.