DEV Community: Devart

Explore the New Release of dotConnect and Entity Developer with EF Core 10, AI Vector Types, and Expanded Database Compatibility

Devart — Thu, 19 Mar 2026 12:28:00 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released new versions of dotConnect and Entity Developer. The new release adds support for Entity Framework Core 10, introduces AI-focused vector data types across major databases, and extends compatibility with the newest platform capabilities such as SQL Server 2025, Oracle 26ai, and Microsoft Entra authentication.

Key enhancements in this release:

Support for Entity Framework Core 10 across all dotConnect providers (except dotConnect for SQL Server and dotConnect Universal) and Entity Developer.

Added Vector data types for AI workloads:

dotConnect for Oracle 11.1: vector data types in Oracle 23ai/26ai, with support for BINARY, INT8, FLOAT32, FLOAT64 in sparse and dense formats.
dotConnect for MySQL 10.1: VECTOR data type support in MySQL.
dotConnect for PostgreSQL 9.1: pgvector types, with support for VECTOR and HALFVEC.
dotConnect for SQLite 7.1: sqlite-vec vector types, with support for BINARY, INT8, FLOAT.

Added new database data types in Oracle and MariaDB:

dotConnect for Oracle 11.1: Boolean data type support in Oracle 23ai/26ai.
dotConnect for Oracle 11.1: JSON data type support in Oracle 21c/23ai/26ai.
dotConnect for MySQL 10.1: Inet6 data type support in MariaDB.
dotConnect for MySQL 10.1: UUID data type support in MariaDB.

Support for SQL Server 2025 and Oracle 26ai:

dotConnect for SQL Server 6.1: support for SQL Server 2025.
dotConnect for Oracle 11.1: support for Oracle 26ai.

NetTopologySuite 2.6 support for spatial workloads:

dotConnect for Oracle 11.1: NetTopologySuite 2.6 support for EF6 in .NET Standard 2.0 assemblies.
dotConnect providers: NetTopologySuite 2.6 support for EF Core in spatial functionality (Oracle, MySQL, PostgreSQL, and SQLite).

Added support for Microsoft Entra authentication in the .NET Standard 2.0 assemblies of the Devart.Data.SqlServer NuGet package.

Full support for modern .NET provider builds in Entity Developer.

To learn more about the recent release and download new products, visit: https://blog.devart.com/new-dotconnect-and-entity-developer-release-ef-core-10-ai-vector-types-and-expanded-database-compatibility.html

dotConnect is a suite of high-performance ADO.NET data providers that enable direct access to major database systems and cloud services. It is a complete solution that helps develop data-related .NET applications and web sites.

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration, and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/.

Meet the new version of SSIS Data Flow Components 4.0: Visual Studio 2026, SQL Server 2025, and Beyond

Devart — Tue, 03 Feb 2026 11:28:37 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released a new version of SSIS Data Flow Components.

What’s new in version 4.0

Support for Visual Studio 2026
Support for Visual Studio 2026 Insiders
Support for SQL Server Integration Services 2025 (SSIS 2025, v17.0)
Support for SQL Server 2025
Support for Oracle 26ai

To learn more about the recent release and download new products, visit:
https://blog.devart.com/ssis-data-flow-components-4-0-ready-for-visual-studio-2026-sql-server-2025-and-beyond.html

Devart SSIS Data Flow Components are powerful tools designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages, allowing users to connect cloud applications and databases through their SSIS workflows without the need to write complex code.

About Devart

dbForge 2025.3: AI Assistant in SQL Complete, Expanded Connectivity, and Smarter SQL Workflows

Devart — Thu, 22 Jan 2026 12:06:37 +0000

Devart, a leading developer of database management software, recently announced the release of dbForge 2025.3, the latest update to its unified ecosystem of professional database tools. The new version delivers expanded connectivity, full support for SSMS 22, Visual Studio 2026, MySQL 9.5, MariaDB 12.2, and Oracle Database 26i, along with UI/UX enhancements, broader SQL syntax coverage, and the introduction of dbForge AI Assistant within SQL Complete.

dbForge AI Assistant Now Available in SQL Complete for SSMS

dbForge AI Assistant is now integrated into dbForge SQL Complete, an SSMS add-in widely used for SQL Server development. By bringing intelligent assistance directly into SSMS, dbForge 2025.3 accelerates query development and helps teams minimize errors without relying on any external tools.

Key features include:

Instant conversion of natural language input to valid SQL code
Generation of queries that are relevant to the context of your databases
Optimization and troubleshooting of pre-written queries
Detailed explanations of SQL query syntax
Analysis and clarifications of query execution errors
AI chat on any issue related to databases and SQL
Built-in web search for the most up-to-date information
Integration with multiple dbForge solutions, including SQL Complete

Expanded Support for the Latest Databases and IDEs

dbForge 2025.3 ensures seamless workflows when upgrading database platforms and development environments. It provides the following updates:

Full compatibility with SSMS 22 across dbForge add-ins
SQL Complete integration with Visual Studio 2026, enabling smart code completion and AI features
Support for MySQL 9.5 and MariaDB 12.2
Support for Oracle Database 26i
Support for AWS RDS Proxy with caching_sha2_password authentication

These updates allow teams to adopt the latest updates without sacrificing tool compatibility or productivity.

Improved Performance Analysis and Database Design

The release introduces enhancements that simplify navigation and performance analysis, especially in complex environments:

Object Search in Database Diagrams, enabling instant location of tables, relationships, notes, stamps, and containers in large ER diagrams
Visual execution plan diagrams for MySQL queries, transforming EXPLAIN output into intuitive visuals that make performance bottlenecks easier to identify and optimize

Expanded SQL Syntax Support Across Platforms

dbForge 2025.3 significantly improves SQL parsing, validation, formatting, and code completion across supported databases, including:

Extended PostgreSQL and Redshift support: WITH clauses, MERGE, and advanced SELECT, INSERT, UPDATE, and DELETE statements
Full support for RETURNING expressions, cursors, and advanced conflict-handling logic
Improved MySQL syntax validation, including support for SHOW BINARY LOG STATUS
Oracle syntax check support for SQL_MACRO functions (SCALAR and TABLE) and pipelined table functions

UI and UX Enhancements for Everyday Productivity

To streamline daily development tasks, dbForge 2025.3 introduces several usability improvements, including:

Scrollbar annotations for faster navigation in large scripts
Automatic wrapping of selected text with quotes, brackets, or parentheses
Updated identifier formatting options, including camelCase, Capitalized, and PascalCase, with full backward compatibility with the existing formatting profiles

Unified Multi-Database Workflows with dbForge Edge

While dbForge 2025.3 focuses on SSMS and SQL Server enhancements, teams working across multiple database systems can explore dbForge Edge. This all-in-one multidatabase solution combines dbForge Studios for SQL Server, MySQL/MariaDB, Oracle, and PostgreSQL, helping organizations streamline database design, development, and management across projects and platforms.

Availability

dbForge 2025.3 is available today.

Users with active subscriptions can upgrade immediately, and new users can explore the release with a free trial.

For more information, visit: https://www.devart.com/dbforge/

New Release of SSIS Data Flow Components with Improved Security and Database Integration

Devart — Tue, 13 Jan 2026 12:59:15 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, rolled out a new release of SSIS Data Flow Components with significant improvements in security and database integration.

Key enhancements in this release:

PostgreSQL 18 support, which allows users to seamlessly integrate with the latest version of PostgreSQL.
Added support for MariaDB 12, enabling smoother and more efficient data operations.
Support for long passwords in Oracle 23ai, it helps Oracle database users manage longer and more secure passwords more easily.
Support for enhanced encryption and key exchange algorithms for SSH - enhances security and protects data during transmission.

To learn more about the recent release and download new products, visit: https://blog.devart.com/ssis-3-2-release.html

About Devart

Meet the New dotConnect 2025.1 Release

Devart — Tue, 23 Dec 2025 13:16:11 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released dotConnect 2025.1. With this release, developers gain higher performance thanks to batch updates, easier cloud connectivity through built-in OAuth, and a cleaner, more modern data access stack focused on current technologies.

The list of key updates:

Support for .NET 10 across all dotConnect providers and LinqConnect
Support for Visual Studio 2026 and Visual Studio 2026 Insiders in all dotConnect providers, LinqConnect, and Entity Developer
dotConnect 2025.1 significantly improves SSH support for dotConnect for Oracle (in Direct mode), dotConnect for MySQL, and dotConnect for PostgreSQL
Added built-in OAuth 2.0 support for cloud database connectivity in dotConnect for Salesforce, dotConnect for Dynamics 365, dotConnect for FreshBooks, dotConnect for Mailchimp, dotConnect for QuickBooks, dotConnect for Zoho CRM, dotConnect for Zoho Books, and dotConnect for Zoho Desk.
Now, Batch Updates is available for dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, dotConnect for SQL Server, dotConnect for DB2, and dotConnect Universal.
Added the PgSqlNumeric structure for the PostgreSQL NUMERIC data type in dotConnect for PostgreSQL

Look at the other improvements:

Added support for SQL Server Reporting Services 2017 (15), 2019 (16), and 2022 (17) in dotConnect for Oracle, MySQL, PostgreSQL, SQLite, and DB2.
Improved OracleLoader performance for LOB types in Direct mode in dotConnect for Oracle
Support for MariaDB 12 and SingleStore (formerly MemSQL) in dotCOnnect for MySQL.
Added support for PostgreSQL 18 in dotConnect for PostgreSQL.
Added support for savepoints in the SQLiteTransaction class in dotCOnnect for SQLite.
Improved the Add Connection dialog in Visual Studio Server Explorer in dotCOnnect for Salesforce MC.
A transparent and unified licensing model is available for the entire dotConnect line.
Entity Developer is now available with Professional and Standard editions. Express remains free, and all editions use key-based licensing.

To learn more about the recent release and download new products, visit:
https://blog.devart.com/dotconnect-2025-1-release.html

About Devart

Meet Major Update of Devart ODBC Drivers: GUI for macOS/Linux, PostgreSQL 18 Support, and Enhanced Security

Devart — Thu, 18 Dec 2025 18:38:30 +0000

Devart, a leading provider of data connectivity solutions for various data connection technologies and frameworks, released updated ODBC Drivers.
The key feature of this release - PostgreSQL 18 and MariaDB 12 support.

The release includes the following updates:

Added a graphical interface for configuring the driver on macOS and Linux.

OAuth 2.0 authorization support on macOS and Linux for Salesforce and Dynamics 365 Drivers.

Support for Bearer Token authentication when using an HTTP tunnel in Oracle, PostgreSQL, QuestDB, Redshift, MySQL, ASE, SQL Server, SQL Azure, and SQL Synapse Drivers.

For ODBC Driver for Oracle:

Added support for REF_CURSOR parameters in stored procedures and functions to retrieve them as Result Sets.
Added support for the BOOLEAN data type in Oracle 23c and later.

The ODBC Driver for MySQL now supports:

MariaDB 12.
Vector data type.
UUID data type in MariaDB 10.7 and later.
INET4 and INET6 data types in MariaDB 10.10 and later.

The PostgreSQL Driver is now fully compatible with PostgreSQL 18.

For the Microsoft Access Driver:

Significantly improved the performance of DML operations within a transaction.
Added the CacheSize and CacheLifetime options to improve performance in the ExclusiveLock mode.

Support for the Canada and Saudi Arabia data centers in Zoho Drivers.

Improved support for the HiPerSix database format for the xBase Driver.

The NexusDB Driver offers support for NexusDB 4.75.17.

The Firebird Driver introduces support for network protocol selection.

Improved compatibility with Linked Servers in MSSMS for the MongoDB Driver.

OAuth 2.0 authorization is available in the Klaviyo Driver.

Extended the list of supported tables in HubSpot Driver.

Added support for the new extended API for Jira Service Management Driver.

To learn more about the recent release and download new products, visit:
https://blog.devart.com/devart-odbc-drivers-get-major-update-with-gui-for-macos-linux-postgresql-18-support-and-enhanced-security.html

ODBC Drivers are high-performance connectivity solutions with enterprise-level features for accessing the most popular database management systems and cloud services from ODBC-compliant reporting, analytics, BI, and ETL tools on 32-bit and 64-bit Windows, macOS, and Linux. Download a 30-day free trial of ODBC Drivers here: https://www.devart.com/products.html#odbc

About Devart

dotConnect for QuickBooks Online | Secure C# ADO.NET connection with ORM support

Devart — Fri, 28 Nov 2025 10:44:40 +0000

In this video, you will learn how to connect your C# .NET applications directly to QuickBooks Online with dotConnect for QuickBooks — a robust, high-performance data provider designed for modern financial integration.

Whether you’re building financial dashboards, automating reports, or syncing accounting data, dotConnect gives you seamless, secure access to QuickBooks Online with full Visual Studio integration and rich ORM capabilities.

Tap the link to watch in full: https://www.youtube.com/watch?v=g9YA1jtdt2Q

Download a 30-day absolutely free trial of Devart dotConnect for QuickBooks Online: https://www.devart.com/dotconnect/quickbooks/download.html

Subscribe to the Devart YouTube channel: https://www.youtube.com/user/DevartSoftware

Let’s take a look at the new page - EF Core Diagram Class Generation and DbContext Visualization

Devart — Thu, 27 Nov 2025 12:54:08 +0000

https://www.devart.com/entitydeveloper/ef-core-diagram.html

The ability to visualize these models is especially valuable. Specialized tools make it much easier for developers to build, customize, and manage EF Core models. One such tool is Devart Entity Developer – a powerful ORM designer for Entity Framework, Entity Framework Core, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. In this article, you will learn more about it.

Download a 30-day absolutely free trial of Entity Developer: https://www.devart.com/entitydeveloper/download.html

dotConnect Universal – Unified Database Access for .NET Apps

Devart — Tue, 25 Nov 2025 11:09:57 +0000

In this video, you’ll unlock true C# universal database connection capabilities with dotConnect Universal — a feature-rich ADO.NET provider that enables seamless data access across SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Db2, and more.

Tap the link to watch in full: https://www.youtube.com/watch?v=5mDkq-46Qmg

Download a 30-day absolutely free trial of Devart dotConnect Universal: https://www.devart.com/dotconnect/universal/download.html

Subscribe to the Devart YouTube channel: https://www.youtube.com/user/DevartSoftware

Devart ODBC Drivers vs Free ODBC and JDBC: Key Comparison

Devart — Mon, 24 Nov 2025 19:02:49 +0000

Devart ODBC Drivers vs Free ODBC and JDBC: Key Comparison

Drivers are more than connectors. They dictate how efficiently data moves between databases, applications, and analytics tools. When overlooked, the entire stack slows down. Breakdowns at this level lead to failed reports, missed deadlines, and avoidable downtime.

In this webinar, we compare free vendor ODBC and JDBC drivers against Devart ODBC Drivers, using PostgreSQL benchmarks to show where professional drivers deliver clear advantages.

Watch the full webinar: https://www.youtube.com/watch?v=7C7D9RBOejU&t=1s

Read the full comparison on our blog: https://blog.devart.com/devart-vs-free-odbc-vs-jdbc.html

Try Devart ODBC Drivers with a free 30-day trial: https://www.devart.com/products.html#odbc

Major Update of Devart Python Connectors: Broader Compatibility and Stronger Security

Devart — Mon, 17 Nov 2025 11:03:51 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, provided a major update of Python Connectors.

Now the products support Python 3.14, PostgreSQL 18, MySQL 9, and MariaDB 12.

The release includes the following enhancements:

Added support for Bearer Token authentication when using an HTTP tunnel for Oracle, PostgreSQL, QuestDB, Redshift, MySQL, ASE, SQL Server, SQL Azure, and SQL Synapse
Password-protected private keys for SSL are available for ASE, MySQL, PostgreSQL, and Oracle
Python Connector for PostgreSQL now offers faster connection initialization, providing faster response times for high-load applications and servers
Python Connector for MySQL supports the UUID, INET4, and INET6 data types
Python Connector for MS Access now offers faster transactional DML with CacheSize, CacheLifetime, and PartialIndex to fine-tune ExclusiveLock performance
Improved support of the HiPerSix database format for Python Connector for xBase
Python Connector for Firebird now lets users choose the network protocol for more flexible connections
Added support for the BOOLEAN data type in Oracle 23 and higher for Python Connector for Oracle
Python Connector for HubSpot now supports more tables, unlocking broader CRM data access for analysis and integration
Python Connector for Zoho CRM works in Canada and Saudi Arabia data centers, enabling regional deployments and local data residency

To learn more about the recent release and download new products, visit:
https://blog.devart.com/new-devart-python-connectors-add-broader-compatibility-and-stronger-security.html

Devart Python Connector is a reliable connectivity solution for accessing database servers and cloud services from Python applications to perform create, read, update, and delete operations on stored data. The solution fully implements the Python DB API 2.0 specification and is distributed as a wheel package for Windows, macOS, and Linux.

About Devart

Let’s take a look at the new page - Getting Started With ODBC Driver for PostgreSQL

Devart — Wed, 29 Oct 2025 13:23:55 +0000

https://www.devart.com/odbc/postgresql/getting-started-guide.html

ODBC (Open Database Connectivity) is a widely used application programming interface (API) that allows client applications to access server-based data sources using SQL.

In this article, you will find detailed information on how to use the ODBC Driver for PostgreSQL.

Download a 30-day absolutely free trial of ODBC Driver for PostgreSQL: https://www.devart.com/odbc/postgresql/download.html