dotConnect is an enhanced data connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. The dotConnect suite includes high-performance data providers for the major database systems and popular cloud services and offers a complete solution for developing data-related .NET 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.
The product line includes programs for Oracle, MySQL, Salesforce, Adobe Commerce, BigCommerce, DB2, Dynamics CRM, Dynamics 365, FreshBooks, Magento, Mailchimp, PostgreSQL, QuickBooks, Salesforce Marketing Cloud, SQL Server, SQLite, SugarCRM, Zoho Books, Zoho CRM and Zoho Desk.
Main 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
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.
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.
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.
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.
Comments and Reviews
dotConnect is one of my most hardworking helpers. I’m using it for years and still haven’t met any worthy alternative. It seems that there's simply no other tool with such wide database connectivity built over ADO.NET.
Thank you. We’re glad to hear you had a great experience with us.
The quickest way to create .NET applications is through dotConnect. period. Pure time-saving.
Thanks a lot. Your feedback is valuable to us.
Thank you so much for your feedback! We do really appreciate it.
Helped me to use LINQ with Oracle and coped with the task just perfectly. Its Entity Developer tool is just great, data changes compile immediately after you make them
We are so grateful for your review.
We've been using dotConnect for several years now. Devart dotConnect is just fantastic. It makes it possible to connect to database without hating it which is uneasy task indeed. I like it because of its direct access to databases without native access, because it works on connected and disconnected models and has the ability to monitor the execution of queries.
Thank you. We’re glad to hear you had a great experience with us.
I found the product to be useful and up to par. A few glitches here and there, but overall it was good.
Forget trying to get support or even purchase the product in a timely manner, though. It takes TWO DAYS to just purchase the product!!! Two days for a download??? Seriously??? What, do they take 48 hour naps???
I chose to use RSSBUS. Immediate response. Instant download. Great company. I don't need two way integration, so this is fine. It costs more but it's worth it to have the peace of mind that you are dealing with a responsive and reputable company. Devart should take heed from RSSBUS.
Thank you for letting us know about your experience. We’ll work on improving to meet our customers’ expectations in the future.