Entity Framework Core Archives

Exploring SQL Server JSON mapping support in Entity Framework Core 9

JSON is a ubiquitous format for defining structured data, and it is increasingly common to see it being stored directly in databases that are primarily relational in nature. Over the past several years, Entity Framework Core has steadily improved its support for JSON, culminating in first-class JSON mapping support in EF Core 8 and EF…

How to dynamically build OR filters in an Entity Framework Core LINQ query

InProgramming

Entity Framework Core is an ORM (Object Relational Mapper) that allows us to leverage LINQ (Language Integrated Query) to abstract away the SQL (Structured Query Language) that would otherwise need to be written for interactions with a database. However, while LINQ is an awesome .NET feature, there are some limitations to be aware of when…

How to catch and parse a SQL Server Duplicate Key Exception

InProgramming SQL

When developing an application that connects to a SQL Server (or Azure SQL) database, you will often want to leverage the features that the database engine provides to help minimise checks that would otherwise need to be performed at the application level. By delegating these checks to the database, you can simplify your application logic,…

A better way to convert enums to strings with Entity Framework Core

InProgramming

By default, Entity Framework Core stores and retrieves .NET enumerations as their underlying integer values for SQL databases, primarily for performance and storage optimization reasons. Nevertheless, if there is a requirement to store enums within your data model as strings at the database level, it is important to have a suitable way to configure this…

Store and retrieve enums as strings with Entity Framework Core

InProgramming

C# enumeration types (enums) provide a highly extensible and type-safe way of storing values and they are used frequently in .NET software development. When enums are saved to a SQL database with Entity Framework Core, by default they are stored using their underlying integer values rather than as strings. There are several reasons for this…

Preventing SQL injection in C# applications

InProgramming Security SQL

SQL injection is a common attack vector that remains one of the most prevalent security risks for applications today. One of the reasons SQL injection attacks are so pervasive is the fact that injection vulnerabilities are very easy for attackers to discover and exploit, sometimes with devastating consequences. On the other hand, mitigating SQL injection…

Implementing an async Repository and Unit of Work with Entity Framework Core

InProgramming

Implementing the Repository pattern in conjunction with the Unit of Work pattern is a best practice for data access that can bring a number of benefits to your application codebase when implemented correctly. Given the ease of use and scalability advantages that async .NET code offers, it makes sense to ensure that your data access…

Tag: Entity Framework Core

Exploring SQL Server JSON mapping support in Entity Framework Core 9

How to dynamically build OR filters in an Entity Framework Core LINQ query

How to catch and parse a SQL Server Duplicate Key Exception

A better way to convert enums to strings with Entity Framework Core

Store and retrieve enums as strings with Entity Framework Core

Preventing SQL injection in C# applications

Implementing an async Repository and Unit of Work with Entity Framework Core

Exploring SQL Server JSON mapping support in Entity Framework Core 9

Working with JSON functions in SQL Server

Using AzCopy to transfer a large number of files between Azure Blob Storage Containers