dbGo 或 dbExpress for Delphi 2010 与 Microsoft SQL Server
我正在迁移到 Delphi 2010，并且正在使用 Microsoft SQL 2000（计划升级到 SQL2008）。我一直在使用 BDE，想知道我是否应该在未来的应用程序中使用 dbGo (ADO) 或 dbExpress。有人可以向我解释使用其中任何一种的优点和缺点吗？
多谢。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我最近遇到了完全相同的困境，想知道是否从 ODBCExpress 迁移到 ADO 或 dbExpress，后者更受开箱即用支持。
最后我的决定非常简单，因为它是为我制定的：dbExpress 是单向的，设计用于执行查询，而不是用于通过数据集进行光标式移动。您必须通过使用 TDataSetProvider 和 TClientDataSet 组件添加额外的支持才能使用网格和其他数据库感知控件。所以这是可以做到的，但额外的层对我来说排除了它。
Zarko Gajic 在他的 delphi.about 上有一篇优秀文章。 com 网站。
我确信其他人会不同意，这很好，我欢迎讨论。
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.
出于性能原因和未来的发展，我将选择 dbExpress。
dbExpress 从最新版本开始就被推高了，但是 dbGo 从 Delphi 5 或 6 开始就没有改变，并且每个版本都只包含一些修复，而 dbExpress 在每个版本中都得到了更多的改进，特别是在最近的几个版本中。
另一个选择是使用 DevArt 的 SDAC，它具有最佳的性能，并且具有针对 Sql 服务器的更多高级功能与其他技术相比。
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.
对于简单的应用程序，J 的解决方案可能足够好，但对于性能是一个问题的客户端/服务器应用程序，我会选择 dbExpress。之前Zarko指出的文章确实是很好的阅读材料。
For simple applications J's soltution might be good enough, but for client / server applications where performance is an issue I'd go for dbExpress. The article by Zarko pointed out before is indeed good reading material.