dotConnect

What is dotConnect?

High-performance ADO.NET providers

dotConnect is an enhanced data connectivity solution built on the ADO.NET architecture and a development framework with several innovative technologies. dotConnect includes high-performance data providers for major databases and popular applications in the cloud and offers a complete solution for developing data-related applications and websites. 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 major databases have a long and successful history of development. With support for cutting-edge ORM solutions such as Entity Framework and LinqConnect, and support for many database-specific types, features, and optimizations, the dotConnect product line introduces new approaches to application design and increases the productivity of database applications development.

Database-specific features

DotConnect providers provide broad support for database-specific features. Support for various modes/connection protocols, database-specific data types. Providers include the Loader component for bulk loading, optimized for a specific data source, the Dump component to save a database or its parts as a script, and restore it from a script.

ORM Support

DotConnect providers support ORMs such as Entity Framework, NHibernate, and LinqConnect - Compatible with Microsoft LINQ to SQL, while extending their functionality with their own capabilities. With its own visual designer for ORM models - Entity Developer .

Microsoft Technology Support

DotConnect database providers support a wide variety of Microsoft data-driven technologies. They can be used in conjunction with the Microsoft Enterprise Library Data Access Application Block, implement multiple ASP.NET providers, as well as ExtendedMembership and ASP.NET Identity providers, to support the Microsoft Sync Framework.

Cloud data connectivity

With standard ADO.NET and Entity Framework interfaces and advanced design time, dotConnect providers for cloud applications provide the fastest way to build .NET applications by working with cloud data. You can set your connection in a design time wizard, link data display controls with dotConnect components, and configure all data accesses visually in a few minutes.

Local SQL mechanism

DotConnect providers for cloud data sources have an on-premises 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, as well as with database data, rather than learning complex web API.

Entity structure support

DotConnect providers for cloud data sources support entity framework and enable you to work with cloud data via LINQ to Entities and Entity SQL. Providers come with their own visual designer for Entity Framework - Entity Developer templates.

Fast Data Loading

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

Unified data access

dotConnect Universal provides universal access to data from different databases for the Microsoft .NET Framework. Supports most 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.

Lights

Advanced Visual Studio integration

DotConnect providers fully integrate with Visual Studio's design-time capabilities. You can use them to create Server Explorer connections and navigate through data source tables, take advantage of dataset designer, data source wizard, query builder, tableadapter configuration, use the View data feature.

RAD approach

DotConnect providers make application development faster because they allow you to quickly configure the data access layer at design time. They offer various GUI tools and visual wizards that increase your productivity. DotConnect components feature advanced visual component editors to simplify your adjustments.

SQL execution monitoring

DotConnect providers have a dedicated tool to monitor the execution of SQL and other data access events - dbMonitor . dbMonitor can be used to monitor any type of application - desktop, ASP.NET and Windows services and even lets you track applications remotely.

Demonstration projects

DotConnect providers follow multiple demo projects, illustrating the use of different technologies and classes with dotConnect and how to use dotConnect providers in different types of projects. They will quickly introduce the use of dotConnect components in their data-related applications.

Useful documentation

Documentation for dotConnect providers can help you get started quickly with providers.

Quick Support

If you have any questions about our suppliers, please contact our support team and we will answer all your questions. We have a response policy in two business days, but you usually get a response much faster.

Royalty Free

DotConnect providers are royalty-free - if you have a license, you won't have to pay any additional fees for deploying or distributing the software to end users.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768