dotconnect
New in ADO.NET Data Providers, Entity Developer, and LinqConnect: .NET and EF Core support implementation, and more
Devart dotConnect line of products has received a significant update that brings long-awaited .NET 5, 6 and 7 support.
Devart’s dotConnect Universal Clinches Bronze in Visual Studio Magazine’s Reader’s Choice Awards
We are thrilled to announce that Devart's dotConnect Universal has been honored with the bronze award in the General Development Tools category at the 2023 Visual Studio Magazine Reader's Choice Awards.
Exploring Dependency Injection in ASP.NET 6
This article builds a simple application to demonstrate the concepts covered and uses PostgreSQL as the database to store data and dotConnect for PostgreSQL as the data provider for PostgreSQL.
How to Work With Hangfire in ASP.NET Core
This article builds a simple application that does some background processing to demonstrate the concepts covered using PostgreSql as the database to store data and dotConnect for PostgreSQL as the data provider for PostgreSQL.
New in ADO.NET Data Providers, Entity Developer, and LinqConnect: Numerous Features and Fixes
Devart dotConnect line of products has received a significant update, making it even more compatible with the latest development environments.
How to implement IP Safelist in ASP.NET 6
This article builds a simple data-centric application and demonstrates how to disallow data access to certain IP Addresses. In this article, we’ll connect to PostgreSQL using dotConnect for PostgreSQL, a high-performance and enhanced data provider built on top of ADO.NET that can work on connected and disconnected modes.
Uploading Files in ASP.NET Core 6 MVC
This article talks about how you can upload one or more files in an ASP.NET Core 6 application.
How to Connect to PostgreSQL in .NET 8 using EF Core and ASP.NET Core
The integration of PostgreSQL with a .NET 6 Web API provides a powerful and flexible solution for building data-driven .NET applications.
Entity Framework Core 7 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.
How to implement health checks in ASP.NET 6
ASP.Net Core is a popular web development framework with many features for building web modern web applications. One of its many great features is the ability to implement health checks to determine the health of APIs, databases, etc. Health checks can help you to know if connections to the database, third-party components, etc., are healthy, degraded, or unhealthy.
Strategies for Versioning RESTful APIs in ASP.NET 6
Consider a scenario where you already have an API live and being used by users. Let's assume you want to enhance existing API capabilities while maintaining existing functionality. While some users may still use the older API, others prefer a version with new or improved features. So, you need a way to build and manage multiple versions of your APIs. This strategy is also known as API versioning.
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...
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...
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...
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...
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)...
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...
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,...
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....
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...
EF Core Support Improvements in dotConnect for PostgreSQL 7.21
The new version of Devart dotConnect for PostgreSQL includes significantly improved support for Entity Framework Core. It both supports the new data types and...
Code-First Migrations and EF Core Support Improvements in dotConnect for SQLite 5.18
The new version of Devart dotConnect for SQLite contains significant improvements of Entity Framework Core support, improving Entity Framework Core Code-First Migrations a...
Devart Stays on Winning Paths with ComponentSource Awards 2021
Once again, ComponentSource announces its Bestsellers of the year. This well-known professional resource researches the popularity of different software products each year. The analysis...
PostgreSQL 13 Support in dotConnect for PostgreSQL, LinqConnect, SSIS Components, and Entity Developer
Devart is glad to announce support for the latest PostgreSQL version - PostgreSQL 13 - in the newly released dotConnect for PostgreSQL 7.19 and...
Improvements for EF Core Support and Monitoring in dotConnect Providers
Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer significant improvements...
Entity Framework Core Spatials Support in dotConnect ADO.NET Providers
The new releases of dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite support Spatial data in Entity Framework Core 3.
Entity Framework Core 3...
Devart Joins the Winners of 2020 ComponentSource Bestselling Awards
The response and appreciation of our users make our company proud of the database solutions we create. This time Devart gladly joins the ranks...
Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards
For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...
SSH Support in SSIS Components 1.14 and dotConnect for Oracle 9.12
Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components...
Entity Framework Core 3.1 Support in dotConnect Providers
Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer you support...
Entity Framework 6.3 and .NET Core 3 Support
.NET Core 3
.NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....
Visual Studio 2019 Support in Devart .NET Connectivity Solutions!
Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers, LinqConnect - our LINQ to SQL-compatible ORM solution,...
Visual Studio 2019 RC4 Support in Devart .NET Connectivity Solutions!
Devart is glad to announce support for Visual Studio 2019 Release Candidate 4 in dotConnect ADO.NET data providers for databases and cloud apps,...
PostgreSQL 11 support in dotConnect for PostgreSQL, LinqConnect, SSIS Components, and Entity Developer
Devart is glad to announce support for the latest PostgreSQL version - PostgreSQL 11 - in the newly released dotConnect for PostgreSQL 7.12 and...
Support for Zoho CRM API v2 in dotConnect for Zoho CRM 1.8
Devart is glad to announce the release of dotConnect for Zoho CRM 1.8 with support of Zoho CRM API v2.
Now you can use Zoho...
New FreshBooks API Support in dotConnect for FreshBooks and SSIS Data Flow Components
Devart is glad to announce the release of dotConnect for FreshBooks 1.8 and SSIS Data Flow Components 1.8 with support of New FreshBooks API...
MySQL 8.0 support in dotConnect for MySQL 8.12
We are glad to announce the release of dotConnect for MySQL 8.12 — a powerful ADO.NET provider for MySQL with advanced support for Entity...
Entity Framework Core 2.1.1 Support in Entity Developer and dotConnect Providers!
Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers and Entity Developer - our visual designer...
JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL
Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...
Entity Framework Core 1 (Entity Framework 7) Support
Entity Framework Core 1, formerly known as Entity Framework 7 (hereafter also called EF Core or EF7), is supported in Devart ADO.NET provider product...
MySQL Case Sensitive Search in Entity Framework
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
