Please try SQL Server Data Access Components 4.00 Beta version available for download now.
Version 4.00 introduces a large number of new features including disconnected model and local failover support,
extended server-specific functionality support and many others.
Here is the description of new features:
New functionality:
- Disconnected model for working offline and automatically connecting and disconnecting supported
- Local failover for detecting connection loss and implicitly reexecuting some operations supported
- Added DataSet Manager to control project datasets
- New TMSScript component for easy execution of multistatement scripts added
- New component for transferring data between all types of TDataSets descendants added
- New TMSLoader component for improving records insertion performance added
- New TMSDump component for loading data to and from the server added
- Data export and import to/from XML supported
- Support for sending messages to DBMonitor from any point of your program added
- Asynchronous fetch mode added
- Ability to work with compressed BLOB objects added
- MS SQL Server Compact Edition supported
- Multiple Active Result Sets (MARS) supported
- Support for new data types, including XML, varchar(MAX), nvarchar(MAX), varbinary(MAX) added
- Support for a new level of transaction isolation (DBPROPVAL_TI_SNAPSHOT) added
- Support for more server objects in TMSMetaData added
- Master/detail functionality extensions:
- Local master/detail relationship support added
- Master/detail relationship in CachedUpdates mode support added - Working with calculated and lookup fields improvements:
- Local sorting and filtering added
- Record location speed increased
- Improved working with lookup fields - Greatly increased performance of applying updates in CachedUpdates mode
- Connection pool functionality improvements:
- Efficiency significantly improved
- API for draining the connection pool added - Ability to customize update commands by attaching external components to TMSUpdateQuery objects added
- Support for DefaultValues on record insertion added
- Improved performance in specific cases:
- NUMERIC fields fetching
- Update commands execution while editing data set
- DataSet refreshing
- Records refreshing after updates and inserts
- Syntax highlighting in design-time editors added
- FAQ section added
- Easy-to-use demo projects
Core Lab development team
http://www.crlab.com/sdac