TinyHelpers.EntityFrameworkCore 3.0.27

dotnet add package TinyHelpers.EntityFrameworkCore --version 3.0.27                
NuGet\Install-Package TinyHelpers.EntityFrameworkCore -Version 3.0.27                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="TinyHelpers.EntityFrameworkCore" Version="3.0.27" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add TinyHelpers.EntityFrameworkCore --version 3.0.27                
#r "nuget: TinyHelpers.EntityFrameworkCore, 3.0.27"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install TinyHelpers.EntityFrameworkCore as a Cake Addin
#addin nuget:?package=TinyHelpers.EntityFrameworkCore&version=3.0.27

// Install TinyHelpers.EntityFrameworkCore as a Cake Tool
#tool nuget:?package=TinyHelpers.EntityFrameworkCore&version=3.0.27                

Tiny Helpers for Entity Framework Core

Lint Code Base CodeQL NuGet Nuget License: MIT

A collection of helper methods and classes for Entity Framework Core that I use every day. I have packed them in a single library to avoid code duplication.

Installation

The library is available on NuGet. Just search for TinyHelpers.EntityFrameworkCore in the Package Manager GUI or run the following command in the .NET CLI:

dotnet add package TinyHelpers.EntityFrameworkCore

Usage

Converters

The library provides some Value Converters to handle data types that are not natively supported by Entity Framework Core. They can be explicitly used calling the HasConversion method, or automatically via some extension methods:

// using TinyHelpers.EntityFrameworkCore.Extensions;
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Post>(builder =>
    {
        builder.Property(x => x.Title).HasMaxLength(80).IsRequired();
        builder.Property(x => x.Content).IsRequired();

        // Date is a DateOnly property (.NET 6 or 7).
        //builder.Property(x => x.Date).HasDateOnlyConversion();

        // Time is a TimeOnly property (.NET 6 or 7).
        //builder.Property(x => x.Time).HasTimeOnlyConversion();

        /* JSON SUPPORT */

        // For .NET 6:
        // Reviews is a complex type, this Converter will automatically JSON-de/serialize it
        // in a string column.
        // builder.Property(x => x.Reviews).HasJsonConversion();

        // For .NET 7 or higher:
        builder.OwnsMany(x => x.Reviews).ToJson();

        /* COLLECTION OF PRIMITIVE TYPES */

        // For .NET 6 and 7:
        //builder.Property(x => x.Authors).HasArrayConversion();

        // For .NET 8
        // The support for collection of primitive types is built-in.
    });
}
Query Filters

The library provides an extension method that allows to apply a global Query Filter to entities:

public abstract class DeletableEntity
{
    public bool IsDeleted { get; set; }
}

public class Person : DeletableEntity { }

public class City : DeletableEntity { }

public class PhoneNumber : DeletableEntity { }

// using TinyHelpers.EntityFrameworkCore.Extensions;
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // Apply a filter to all the entities that inherit (directly or indirectly) from DeletableEntity.
    modelBuilder.ApplyQueryFilter<DeletableEntity>(e => !e.IsDeleted);
}

Contributing

The project is constantly evolving. Contributions are welcome. Feel free to file issues and pull requests on the repo and we'll address them as we can.

Warning Remember to work on the develop branch, don't use the master branch directly. Create Pull Requests targeting develop.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.0.27 1,495 10/9/2024
3.0.25 412 9/2/2024
3.0.24 667 7/10/2024
3.0.22 174 6/19/2024
3.0.19 1,686 5/15/2024
3.0.18 274 5/14/2024
3.0.17 146 5/9/2024
3.0.14 5,432 3/26/2024
3.0.12 344 2/27/2024
3.0.8 992 2/14/2024
3.0.6 237 2/12/2024
3.0.3 3,178 1/11/2024
3.0.2 6,558 11/21/2023
2.0.21 12,877 9/4/2023
2.0.20 4,238 6/29/2023
2.0.19 887 6/14/2023
2.0.18 3,839 4/12/2023
2.0.17 587 4/10/2023
2.0.16 1,894 3/27/2023
2.0.14 10,563 3/15/2023
2.0.13 1,244 3/1/2023
2.0.12 1,473 2/21/2023
2.0.10 4,232 1/11/2023
2.0.9 632 1/9/2023
2.0.4 954 11/30/2022
1.0.76 2,078 10/31/2022
1.0.72 6,909 9/21/2022
1.0.61 9,832 7/25/2022
1.0.59 1,062 6/30/2022
1.0.57 793 6/21/2022
1.0.56 1,573 6/2/2022
1.0.52 9,864 3/28/2022
1.0.48 1,537 2/7/2022
1.0.45 4,037 1/25/2022
1.0.43 770 1/20/2022
1.0.34 973 1/7/2022