dotconnect

Consume a RESTful API Using RestSharp and C#

This article talks about REST concepts, the RESTSharp library, and how it can be used to work with RESTful APIs in ASP.NET 6. We’ll use a PostgreSQL database using Devart dotConnect for PostgreSQL to store and retrieve data.

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

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

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

4 Ways to Test an ODBC Connection

Are you looking for different ways to test an ODBC connection? In this article, we will discuss 4 easy ways to test the connectivity and show how to do it with examples.

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

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

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