dotConnect Team posts

SSIS Multicast Transformation: The Smart Guide with Easy Examples

SSIS MultiCast could be the easiest transformation component. Why?

You simply drag it into the Data Flow. Then, point the source to it and point it to one or more transformation or destination components. That’s it. There’s nothing else to configure. But what is it? And how do you use it? This article will show you how to use it with simple examples.

(more…)

Implementing Rate Limiting in ASP.NET 6 Core and C#

Throttling and rate limiting restrict API access, but they serve different purposes. While rate limiting can limit API usage to ensure stability, throttling prevents users from accessing your APIs over a certain period.

(more…)

Make SSIS DateTime Expressions Easy With DATEPART, DATEADD, and DATEDIFF

SSIS DateTime expressions are mostly a part of daily ETL tasks. And the functions that come to mind are DATEPART, DATEADD, and DATEDIFF.

(more…)

SSIS Data Types: The No-Sweat Guide with Easy Examples

Have you ever wondered why you need to mind your SSIS data types? You DO actually need to mind them, because there are numerous data types amounts which, sometimes, as oil and water, don’t mix together. Proceed into the article to know a little bit more about the SSIS universe!

(more…)

Key Difference between ADO.NET and ASP.NET

When we plan to develop any web-based application using the .NET Framework, we need to use ASP.NET for development. But, while we are using ASP.NET for any application development, we can also use ADO.NET within that application. We often misunderstand that ASP.NET and ADO.NET are the same or related. But actually, it is not valid. Both are different in the concept of feature and functionality. But definitely, we can use both of them at a time within an application. So, here, we will mainly discuss the critical difference between ADO.NET and ASP.NET. 

(more…)

How to Write Expressions in SSIS Derived Column

You can’t make an SSIS Derived Column useful without expressions. So, how do you write one? This article will give you tips on using derived column transformation.

(more…)

Scheduling Cron Jobs in ASP.NET 6 and C#

This article covers cron jobs and how we can leverage Quartz.Net to schedule cron jobs in ASP.NET 6. It shows how we can store messages in a PostgreSQL database using Devart for PostgreSql, Quartz.Net, and ASP.NET 6.

(more…)

Visual Studio 2022 Support in Devart .NET Connectivity Solutions

Devart is glad to announce the release of the new versions of multiple high-performance ADO.NET data providers, LinqConnect, and Entity Developer.

(more…)

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