dotConnect Team posts

How to Work With Inheritance in Entity Framework Core

Entity Framework Core from Microsoft is a cross-platform, lightweight, and flexible version of its predecessor, Entity Framework. EF Core is an object-relational mapper (ORM) tool that offers a standardized way of storing and retrieving data to and from diverse data sources.

(more…)

Incremental Load in SSIS

People are ever more in a hurry. They want their data almost right now. And even more, data is getting bigger and bigger. So, you can’t use good old techniques because they’re “good enough”. It has to be fast. And ETL steps are not an exemption. This is where incremental load comes to play. And if you’re on this page, you probably are looking for incremental load in SSIS.

(more…)

The Ultimate Comparison of ADO.NET and Entity Framework

When developers start working on any applications (for both web or desktop versions), they spend a long time worrying about the backend database, its tables, and their relationships, stored procedures, views, etc. Along with this, they also need to consider the data schema which will return from the backend part for the application. For this type of operation, we can use many available frameworks such as DAO, RDO, ADO, ADO.NET, Entity Framework, etc. Out of these different frameworks, the most commonly used frameworks are ADO.NET and Entity Framework. So, after reading this article,  you will get a clear understanding of the following topics supported with clear examples:

(more…)

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…)

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox