Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

High-performance ADO.NET Data Providers

dotConnect is an enhanced data connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. dotConnect includes high-performance data providers for the major databases and popular cloud applications and offers a complete solution for developing data-related applications and web sites. dotConnect can be used in all areas of modern application development: web applications and services, Windows Forms applications, mobile applications, and even enterprise-grade solutions.

Database Connectivity

dotConnect providers for the major databases have a long and successful history of development. With support for state-of-the-art ORM solutions such as Entity Framework and LinqConnect, and support for lots of the database-specific types, features, and optimizations, dotConnect product line introduces new approaches for designing applications and boosts the productivity of database application development.

Database Connectivity

With the standard ADO.NET and Entity Framework interfaces and advanced design-time, dotConnect providers for cloud applications offer the fastest way to create .NET applications, working with cloud data. You can define your connection in a design-time wizard, bind data-display controls with dotConnect components, and configure all the data access visually in few minutes.

Cloud Data Connectivity
Local SQL Engine

Local SQL Engine

dotConnect providers for cloud data sources have a local SQL engine that allows you to select data with standard SQL SELECT statements and modify data with INSERT, UPDATE, and DELETE statements. They allow you to work with cloud data via SQL, just like with database data, instead of learning a complex web API.

dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports most of major database servers, including Microsoft SQL Server, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, Microsoft Access, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

Main features

Database-specific Features

Database-Specific Features

dotConnect providers offer wide support for database-specific features. They support various connection modes/protocols, database-specific data types, etc. The providers include the Loader component for bulk data loading, optimized for a specific data source, the Dump component for saving a database or its parts as a script and restoring it from a script.

ORM Support

ORM Support

dotConnect providers support such ORMs as Entity Framework, NHibernate, and LinqConnect - our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features. The providers come bundled with their own visual designer for ORM models - Entity Developer.

Microsoft Technology Support

Microsoft Technology Support

dotConnect providers for databases support a wide array of Microsoft data oriented technologies. They can be used in conjunction with Microsoft Enterprise Library Data Access Application Block, implement various ASP.NET providers as well as ExtendedMembership providers and ASP.NET Identity 1 and 2, support Microsoft Sync Framework, etc.

Secure Connection

Secure Connection

When establishing an ODBC connection to the server, it is important to securely exchange data. Our data providers support encrypted connections using SSL and SSH data encryption, as well as HTTPS tunneling.

Entity Framework Support

Fast Data Loading

For most of the supported cloud sources, dotConnect providers offer a Loader class, which allows bulk data loading to the data source and can quickly upload a large number of records. The Loader class loads data in batches and you can control the number of records to load as one batch.

Fast Data Loading

Entity Framework Support

dotConnect providers for cloud data sources support Entity Framework and allow working with cloud data via LINQ to Entities and Entity SQL. The providers come bundled with their own visual designer for Entity Framework models - Entity Developer.

Highlights

Advanced Visual Studio Integration

Advanced Visual Studio Integration

dotConnect providers tightly integrate with the design-time features of Visual Studio. You can use them to create Server Explorer connections and browse data source tables, take advantage of DataSet Designer, Data Source wizard, Query Builder, TableAdapter configuration, use Preview Data capability, etc.

RAD Approach

RAD Approach

dotConnect providers make application development faster because they allow to quickly configure the data access layer at design-time. They offer a number of visual GUI tools and wizards that increase your productivity. dotConnect components have advanced visual component editors to simplify their tweaking.

SQL Execution Monitoring

SQL Execution Monitoring

dotConnect providers have a dedicated free tool for monitoring SQL execution and other data access events - dbMonitor. dbMonitor can be used for monitoring any kind of applications - desktop, ASP.NET and windows services and even allows tracing the applications remotely.

Demo Projects

Demo Projects

dotConnect providers go with a number of demo project, illustrating the use of different technologies and classes with dotConnect and how to use dotConnect providers in different kinds of projects. They will quickly introduce you to using dotConnect components in your data-related applications.

Helpful Documentation

Helpful Documentation

Documentation for dotConnect providers can help you get started with them quickly. It is integrated with Visual Studio help collection when a provider is installed and is available separately both as a downloadable CHM file and online on our website.

Fast Support

Fast Support

If you have any questions on our providers, you can contact our support team, and we will answer all of your questions. We have a two-business-day response policy, but usually you will get a reply much faster. We provide support by e-mail or on our forum.

Free Updates for 1 Year

Free Updates for 1 Year

When you purchase any of dotConnect providers, you get an annual subscription for free, and can freely download all the product updates for 1 year since the purchase.

Royalty Free

Royalty Free

dotConnect providers are royalty-free - if you have a license, you won't need to pay any additional fee for deploying or distributing your software to end users.

World-Class Data Connectivity Solutions

ADO.NET - ODBC - SSIS - Excel Add-ins - Delphi - OData

Related Products