General usability
- Real RAD for database applications
- Full compliance with ADO.NET
- 100% managed code
- Highly usable design-time support
- Easy deployment
Performance and efficiency
- High performance
- SqlLoader component for rapid data loading
- SqlScript component to execute scripts with streaming support
- Advanced connection pooling feature
- Paginal access to query result
- Asynchronous execution support
Data access and manipulation
- Direct access to SQL Server within 100% managed code
- Operation in both connected and disconnected models
- Powerful SqlDataTable component to retrieve and manipulate data
- SqlSelectStatement class for building SELECT statements
- Ability to retrieve metadata information
- Support for all SQL Server data types
Data binding and interaction
- DataLink component for flexible data binding
- Cross-form components cooperation
- TableMappings editor
- ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
Design-time and development tools
- Advanced design-time editors
- DataSet Manager and DataSet Editor
- DataSet Wizard to leverage design-time setup
- Generate DataSet Wizard
- Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
- Advanced integration with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019, and 2022, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder, and configuring web component SqlDataSource
- Help integrated into Visual Studio and CodeGear Delphi
Monitoring and query execution
- Ability to monitor query execution
Support and licensing
- Included annual dotConnect for SQL Server subscription with Priority Support
- Licensing per developer, per team, or per site with no royalty fee