dotConnect Team posts

Support for New Data Types and Other Improvements in dotConnect for Oracle 9.16

The new version of Devart dotConnect for Oracle contains improvement of Entity Framework Core: the support of new data types Uri, IPAddress, PhysicalAddress, and expanded ability to translate LINQ queries into SQL. Further, the support for Entity Framework Core Spatial Data functionality used to work with Oracle Spatial and Graph has expanded.

(more…)

Support for New Data Types and Other Improvements in dotConnect for MySQL 8.21

The new version of Devart dotConnect for MySQL contains significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress, PhysicalAddress and expanded the capabilities for translating LINQ queries into SQL. Besides, we improved support for working with JSON in LINQ queries for EF6.

(more…)

Support for Load Balancing and Other Improvements in dotConnect for PostgreSQL 7.24

The new version of dotConnect for PostgreSQL offers support for load balancing. It allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

(more…)

SSIS Execute Process Task Tutorial with Examples

What’s the big deal with SSIS Execute Process Task?

Among the many SSIS components, Data Flow and SQL tasks are enough for simple tasks. Using SSIS to compare two tables is one example. But sometimes, those task components alone are not enough for our requirements. Executing a batch file, a PowerShell script, or an executable file as the next step makes sense. So, why not make use of it in SSIS?

(more…)

Handle Concurrency Conflicts in ASP.NET Core and Oracle

Concurrency conflicts arise due to concurrent access to a shared resource. This article explores ways to handle concurrency conflicts using ASP.NET Core and Oracle. To connect to Oracle, dotConnect for Oracle will be used.

(more…)

Entity Framework Core 6 Support in dotConnect Providers

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, and SQLite. New versions of Devart providers support Entity Framework Core 6.0 and its new features.

(more…)

Excel 2021 Support and More Updates in Excel Add-ins 2.6

Devart is glad to announce the release of Excel Add-ins 2.6 with support for Microsoft Excel 2021, renamed and updated Excel Add-in for G Suite, and more cloud objects supported in other add-ins.

(more…)

PostgreSQL 14 Support in dotConnect for PostgreSQL

Devart is glad to announce support for the latest PostgreSQL version — PostgreSQL 14 — in dotConnect for PostgreSQL 7.22. Now you can connect to PostgreSQL 14, work with stored procedures, returning data via OUT parameters, and multirange data types in your .NET projects.

(more…)

Update Entity Developer and Related ADO.NET Providers to Prevent Errors with Opening Models

Important information for all Entity Developer users on Windows 10 and Windows 11, both as a separate product and included into other products: dotConnect providers with ORM support and LinqConnect.

(more…)

27 New Data Sources Supported in Devart SSIS Components 2.0!

Devart is glad to announce the release of SSIS Data Flow Components 2.0 with support for 27 new data sources. We have supported Snowflake cloud data warehouse and a number of cloud applications, including several new inventory management solutions, like DEAR Inventory or Zoho Inventory, a number of new cloud CRMs, such as Pipedrive and Insightly CRM.

SSIS Data Flow Components now also support new cloud app categories, for example, Ads and Conversion, with such widely used tools as Google Analytics, Google Ads, and Twitter Ads. See the full list of the sources below:

(more…)