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