dotConnect Team posts

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.

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.

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:

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.

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.

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.

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?

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.

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.

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.