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 and enterprise development.

 

 

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 productivity of database application development.

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 Loader component for bulk data loading, optimized for a specific data source, Dump component for saving a database or its parts as a script and restoring it from a script.

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

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.

 

 

Cloud Data Connectivity

With the standard ADO.NET and Entity Framework interfaces and advanced design-time dotConect 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.

Local SQL Engine

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

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.

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.

 

Salesforce Dynamics CRM SugarCRM Zoho CRM QuickBooks FreshBooks MailChimp ExactTarget BigCommerce Magento

 

 

 

 

Unified Data Access

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.

Highlights

Advanced Visual Studio Integration

dotConnect providers tightly integrate with 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

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

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

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

Documentation for dotConnect providers can help you get started with the providers 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

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

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

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.

What people say

I've been impressed with the communication we've received from Devart, and we've recommended to the client that we go with you as our solution provider.

Paul Reynolds, Planet Software

Currently we are already using some years the corelab-devart-dotconnect and are really happy about it.

Frederik Goethals, Analyst - Developer, Sadef nv